How to check isNull on a report

P

pokdbz

I have a field which the control source is Alcohol_01 and the field will
contain a number but on the report if it contains a number I would like that
number to show up and if it isNull then I would like it to display N/A how do
I go about formating this.
 
B

Brendan Reynolds

=NZ([Alcohol_01],"N/A")

Make sure the name of the text box is not the same as the name of the field,
otherwise Access will complain about the control having a reference to
itself.
 
Top