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.
 
Back
Top