field caption

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

Guest

when creating a report, data in some fields may not be available. how do I
make the field headings (captions) disappear (hide) when there is no data for
a field?
 
I assume you are referring to labels. Are these in the detail section or in
group, report, or page headers?

Duane Hookom
MS Access MVP
 
These are in the detail section. And yes I'm referring to labels that would
hide or disappear when there is no data in the control box. Trying to save
space when printing the report for a large manual.
 
One non-code method is to change the labels to text boxes and set their
control sources to something like:
="First Name: " + [FirstName]
Make sure:
1) the control is only wide enough to display "First Name:"
2) the control is set to Can Shrink=Yes and Can Grow=No.
Using the "+" will cause the entire text box to be Null if [FirstName] is
Null.

Duane Hookom
MS Access MVP
 
Back
Top