Conditional Formatting in Report: Font Size

  • Thread starter Thread starter David Frick
  • Start date Start date
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.
 
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
 
Back
Top