Report-blank spaces and labels

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

Guest

Hell

I have a report formed in which I have labels associated with fields (data). Some of the fields are blank and taking up alot of space. I am intested only in the fields that have data. Is there a way to get rid of the blank spaces and associted labels when the field is null (blank). Any help would be greatly appreciated
 
Change the labels to text boxes and set their control sources to an
expression like:
="My Label Caption " + [MyField]
set the width of the "label" text box to show only the caption part and
don't allow it to grow. Set its Can Shrink property to Yes. Also set the
other text box to Can Shrink. If the field is Null, then the "label" and the
text box will both shrink.

--
Duane Hookom
MS Access MVP


svuono4 said:
Hello

I have a report formed in which I have labels associated with fields
Click to expand...
(data). Some of the fields are blank and taking up alot of space. I am
intested only in the fields that have data. Is there a way to get rid of
the blank spaces and associted labels when the field is null (blank). Any
help would be greatly appreciated.
 
Back
Top