Making fields on report invisible 1

[robojeff]

I have a report which I would like to turn a certain text box on or off depending on whether the record source for the text box is null.

The record source for the report is a query and if the field is not null, then I would like to print text box and it's label but if it is null, then I
do not want the label or the text box to appear.

Because there may be several items from my query that will populate the detail scetion of my report, how can I set my report so that the field is
invisible if the data is null and visible if there is data in the field?

thank you

 

[lameid]

In the On Format Event put code that sets the visible property of the control(s) according to the value (you'll need the is null function).

 

[robojeff]

Thanks lameid...

that works great...