Change font size when value changes in a field in a report

[Betina Maersk]

In a report I have a field that contains either the
text "ok" or "warning". If the field contains "warning" I
want the font to be bigger and red. Is that possible?

Thanks
Betina

 

[Allen Browne]

In Access 2000 or 2002:
1. Open the report in Design view.
2. Select the text box you wish to format.
3. Choose Conditional Formatting on the Format menu.

In earlier versions, you need to use code in the Format event of the Detail
section.