Filling in gaps in a Report when a field/s is empty 1

[stealth3]

I have a report where some fields are not always populated. I have written code so that if empty the field is not visible in the report. However the white space remains.

Is there additional code to "keep all the fields together"? The code in the (On Format) section of the Page Header is:

If IsNull(name_of_field) Then
Me.name_of_field.Visible = False
Else
Me.name_of_field.Visible = True
End If

thank you

 

[lupins46]

A field which is not visible is still present so it still takes up space. If you want to recover the space you can set the textboxes 'can shrink' property to yes and then in code set the values to null when not required (ans visible = false if there are borders to consider).

 

[GingerR]

If it takes up an entire section (DETAIL, or a HEADER section) you can also go into the section's OnFormat event and set CANCEL = TRUE and it won't show that section at all.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stealth3]

Thank you both for your help. Ensuring that 'can shrink' yes was selected and also for the background worked.

cheers