Hide Textboxes on Reports (1 Viewer)

[Ivan Howard]

Hi All,

Please could someone kindly help me.

I am creating a basic labelling report, but in some cases have missing data in one field... when this happens, I need to move the following address line up so that it appears that there is no blank line.

I have tried to reduce the height of the text box significantly, whilst turning on the "Can Grow" and "Can Shrink" features... and this has only sort of worked as the start of the next label can be seen on the same label preview as the previous label.

Another idea I have had is nested IIFs, but this could be a huge statement as I have 8 fields to put onto the label.

Any ideas?

 

[Dennisk]

set the can grow and can shrink property of the text box to yes

 

[Rabbie]

You could also use VBA code to set the .visible property of the text box to No if you want to hide it.

 

[Ivan Howard]

Thanks very much to both Dennisk and Rabbie.

I have used the grow and shrink controls and a page break which is working ok.

Thanks vey much again.