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

N

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...
 
J

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
 

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

Report to display total number of empty fields 2
Controlling text fields in access 2002 3
hide the same record in report details 7
Consecutive record fields in a report 6
Want to Hide blank fields in a single record 4
Hide all empty fields in a report 3
A) 140 fields in a record -- OK ?? --- B) Do empty fields use disk space? 6
Hide fields in a report if the value is null 6

Top