font size in conditional formatting

[ameedoo3000]

how can i change the font size of text box in conditional formatting in Access report

[Gina Maylone]

Quick answer from the web:

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

[CJ_London]

you can't with conditional formatting. Gina's suggestion will work for single reports, but will affect all rows in a continuous report.

[June7]

Ajax, are you confusing report with form?

Code in report OnFormat event of the section containing the controls should dynamically set font based on parameter. Works for me. But only for PrintPreview or direct to printer. ReportView does not trigger Format event.

[CJ_London]

think I am!