Hide text box if value is null or display like *this - incorrect c

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

Guest

Hi guys, I'm updating an old report from Access 97. I have two fields which I
want to hide if the values are null or I want to display a certain way if
they contain data.

The code on the original Access 97 form applied to each text box is:

=IIf(Not ([nsn] Is Null),"NSN:" & [NSN])

And this works on the old system but when I enter this code in access 2003 I
get an error message saying that the field has a circular reference? Any
ideas?

The field name is NSN in caps so I assume I change the lower case nsn to NSN.
 
OH never mind I'fe figured it out guys. That code does actually work but it
needs to be set to a blank text box and not actually to my NSN and Pattern
fields.
 
Back
Top