Change a field with the value NIL to nothing in a report?

[Richard Horne]

Hi guys,

I have a report which has two fields called NSN and PATTERN, the default
value on the entry forms for these fields is NIL as most times these fields
will not be filled in.

I have these on a report without a field header, so NILs in the middle of a
report look a bit out of place, so how can I make it so that if those fields
are equal to NIL then nothing is displayed, but if an actual entry has been
made then that entry is displayed instead?

I'm guessing it's something along the lines of

If Me='NIL' then display nothing

But I don't know how to write this in code that Access will understand.

 

[Allen Browne]

Set the Control Source of this text box to:
=IIf([NSN] = "NIL", Null, [NSN])
Then change its Name property as well.