conditional formatting and Runtime

I have created an application that includes a report with conditional
formatting. There are three options, one is a normal font, one is a
highlighted font, and one is a bold font. The text box is set to "Can grow",
and the report prints fine when printed to through Access. However, when the
report is printed through the Runtime application, the text box will not wrap
to the next line if the option is in bold, if I change the option to plain
text it will wrap in the Runtime application. Any suggestions?

There are several factors that can affect how a report is formatted. The
issue suggests there is some problem in calculating the font metrics for the
report. Since the runtime is actually the same executable as the full
msaccess, it is unlikely that it could cause the discrepency, so we need to
look at the other factors.

Firstly, start your database with using a shortcut that uses the /runtime
switch, e.g.:
"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\MyPath\MyFile.mdb" /runtime
If you can demonstrate the problem under these conditions, it is indeed a
runtime issue.

If not, then the problem is not a runtime issue. It could be:
a) A printer driver issue.
Quite common. Try a completely different kind of printer. If the problem
disappears, your client needs to get an updated driver.

b) A font with bad metrics.
See if the problem disappears with Arial or Times New Roman.

c) A service pack issue.
There are service packs for the runtime. This is less likely than the other
two, but it's always worth installing the packs anyway.

HTH.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"smcgart" wrote in message
...
I have created an application that includes a report with conditional
formatting. There are three options, one is a normal font, one is a
highlighted font, and one is a bold font. The text box is set to "Can
grow",
and the report prints fine when printed to through Access. However, when
the
report is printed through the Runtime application, the text box will not
wrap
to the next line if the option is in bold, if I change the option to plain
text it will wrap in the Runtime application. Any suggestions?

Sorry, guess I should have mentioned that, yes I can duplicate the problem
using the runtime switch.

"Allen Browne" wrote:

There are several factors that can affect how a report is formatted. The
issue suggests there is some problem in calculating the font metrics for the
report. Since the runtime is actually the same executable as the full
msaccess, it is unlikely that it could cause the discrepency, so we need to
look at the other factors.

Firstly, start your database with using a shortcut that uses the /runtime
switch, e.g.:
"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\MyPath\MyFile.mdb" /runtime
If you can demonstrate the problem under these conditions, it is indeed a
runtime issue.

If not, then the problem is not a runtime issue. It could be:
a) A printer driver issue.
Quite common. Try a completely different kind of printer. If the problem
disappears, your client needs to get an updated driver.

b) A font with bad metrics.
See if the problem disappears with Arial or Times New Roman.

c) A service pack issue.
There are service packs for the runtime. This is less likely than the other
two, but it's always worth installing the packs anyway.

HTH.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"smcgart" wrote in message
...
I have created an application that includes a report with conditional
formatting. There are three options, one is a normal font, one is a
highlighted font, and one is a bold font. The text box is set to "Can
grow",
and the report prints fine when printed to through Access. However, when
the
report is printed through the Runtime application, the text box will not
wrap
to the next line if the option is in bold, if I change the option to plain
text it will wrap in the Runtime application. Any suggestions?

Hopefully someone else can contribute: I have not seen this particular
problem.

Presumably you are talking about the conditional formatting built in to
A2000 and later. Is there also code in the report's events that could be
affecting the format?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"smcgart" wrote in message
...
Sorry, guess I should have mentioned that, yes I can duplicate the problem
using the runtime switch.

"Allen Browne" wrote:

There are several factors that can affect how a report is formatted. The
issue suggests there is some problem in calculating the font metrics for
the
report. Since the runtime is actually the same executable as the full
msaccess, it is unlikely that it could cause the discrepency, so we need
to
look at the other factors.

Firstly, start your database with using a shortcut that uses the /runtime
switch, e.g.:
"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\MyPath\MyFile.mdb" /runtime
If you can demonstrate the problem under these conditions, it is indeed a
runtime issue.

If not, then the problem is not a runtime issue. It could be:
a) A printer driver issue.
Quite common. Try a completely different kind of printer. If the problem
disappears, your client needs to get an updated driver.

b) A font with bad metrics.
See if the problem disappears with Arial or Times New Roman.

c) A service pack issue.
There are service packs for the runtime. This is less likely than the
other
two, but it's always worth installing the packs anyway.

HTH.

"smcgart" wrote in message
...
I have created an application that includes a report with conditional
formatting. There are three options, one is a normal font, one is a
highlighted font, and one is a bold font. The text box is set to "Can
grow",
and the report prints fine when printed to through Access. However,
when
the
report is printed through the Runtime application, the text box will
not
wrap
to the next line if the option is in bold, if I change the option to
plain
text it will wrap in the Runtime application. Any suggestions?