field caption

M

mitzfidelle

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?
 
D

Duane Hookom

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
 
L

lunar21

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

Duane Hookom

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
 
Top