IIF print color?

[devouru]

I know the format is wrong, but the idea is right. Can I do IIF [value] is
Null print red, [value] print black?

TIA, JS

 

[devouru]

Ooops, nothing to print IIF NULL, but any value will do. You know what I
mean.

-JS

 

[John Spencer (MVP)]

Take a look at the format property. That will allow you some control on
changing color of a textbox when printing. If you are using Access 2000 or
later, take a look at Conditional formatting.

Ooops, nothing to print IIF NULL, but any value will do. You know what I
mean.

-JS

I know the format is wrong, but the idea is right. Can I do IIF [value] is
Null print red, [value] print black?

TIA, JS