How to check isNull on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a status designation from 5 date fields using "Not IsNull" 10
if not isnull then 3
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Checking for changed textboxes 1
VBA code for my report 5
Blank Fields in Report 2
HELP WITH TAB CONTROL - HIDING FIELDS 7
IsNull 17

Back
Top