Conditional Formatting in Report: Font Size

D

David Frick

Is it possible to specify the font size of a textbox on a report if certain
conditions are met?

I can conditionally specify bold, coloring, etc but I do not see how to set
the actual font or font size.
 
M

Marshall Barton

David said:
Is it possible to specify the font size of a textbox on a report if certain
conditions are met?

I can conditionally specify bold, coloring, etc but I do not see how to set
the actual font or font size.
Click to expand...

You don't really need Conditional Formatting in reports.
This can easily be done in code in the Format event of the
text box's section:

With Me.thetextbox
If <condition> Then
.FontSize = 12
.ForeColor = vbRed
.FontWeight = 700
Else
.FontSize = 10
.ForeColor = vbGreen
.FontWeight = 400
End If
End With
 
Top