blank spaces in reports--Please help

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

Guest

Hellointested 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. And I am not fimilar with code, and at this time whish I was!!!!!!
 
svuono said:
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. And I am not fimilar with code, and at this time whish I was!!!!!!
Click to expand...


Add a line of code like:

Me.textboxA.Visible = Not IsNull(Me.textboxA)

for each text box you want to hide when its value is Null.

Set each of those text boxes' CanShrink property to Yes.

Also set the CanShrink property of the section containing
the text boxes to Yes.
 

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
Report-blank spaces and labels 1
How do I suppress blank lines in reports 1
create a blank report 3
Displaying blank space when no data in subreport 5
2 related questions 5
add blank lines to report 4
Completely Blank Report...no title, data, etc. 3

Back
Top