Changing font size of a text box

[George Slamowitz]

I am looking for a code snipplet to change the font size
of a text box on a report. The font size will be a field
(part of the query) used to generate the report.

Any help would be appreciated .....
Thanks in advance for any help you can offer


George H. Slamowitz

 

[Duane Hookom]

Add a text box to the report and bind it to the fontsize field. Name it
txtFontSize. Then in the On Format event of the report section, add code
like:
Me.txtResizeMe.FontSize = Me.txtFontSize

 

[Fredg]

George,

You can code the Section's Format event:
If [SomeControl] = Whatever
[SomeControl].FontSize = 12
Else
[SomeControl].FontSize = 10
End If