How can I hide empty fields in a report in Access 2003?

[Nate]

I have a report based on a select querry which returns specific data but,
depending on the record, some fields may be empty. I would like to setup a
few of these fields to hide if they are empty. Anyone have any ideas? I'm a
little surprised that this isn't a standard option...

 

[Jeff Boyce]

Nate

It IS a standard option, but that doesn't make it easy to find!

Open the report in design view. Select one of the "to-be-hidden" controls
(textbox). Open the Properties window.

Find the CanGrow and CanShrink properties and set them both to "Yes".

If there are no other controls directly aligned (horizontally) with the
control in question, the textbox (and its corresponding/attached label
control) will disappear when there is a Null in the field.

NOTE: Null <> zero-length string (zls) ... make sure your 'blanks' are
Nulls!
NOTE: the attached label must be attached. If you add a "naked" textbox,
then add a label control, the label isn't attached.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP