Conditional Formatting in Report: Font Size

[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.

 

[Marshall Barton]

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.

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