Formatting in Reports

  • Thread starter Thread starter Patricia
  • Start date Start date
P

Patricia

I am using the following formula and need to know if I can
bold out certain parts of formula when it prints on the
report. Is it possible to make A, C and IP bold on the
report?

=IIf([A]=58,[A] & " " & & "IP:" & [C] & " " & [D]
& " " & [E] & " " & [F],"")

Thanks
 
Patricia said:
I am using the following formula and need to know if I can
bold out certain parts of formula when it prints on the
report. Is it possible to make A, C and IP bold on the
report?

=IIf([A]=58,[A] & " " & & "IP:" & [C] & " " & [D]
& " " & [E] & " " & [F],"")
Click to expand...



No, not in a single text box. A text box's formatapplies to
its entire contents.

You would have to either us separate text boxes for the
parts with different formats, or use an ActiveX RTF control.

The former is a bit messy to code the the sizes and position
of the text boxes so they look good together.

The later might be expensive and will probably have
versioning problems.

For either approach, search through Stephen Lebans site at
www.lebans.com for examples and code.
 
No, that would require a Rich Text control. I know that MVP Stephen Lebans
has a good one that is free (http://www.lebans.com), but I don't know if it
works on Reports or just on Forms.

Larry Linson
Microsoft Access MVP
 
Back
Top