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.
 

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

Blank Spaces 1
blank spaces in reports--Please help 1
How do I suppress blank lines in reports 1
2 related questions 5
Displaying blank space when no data in subreport 5
How to hide a text field label when the field is null? Access2003 3
Null Values in reports 4
Suppress Label for Blank Data 12

Back
Top