Making a Label invisible

[sbarron76]

Good day. Your help would be appreciated on my issue. I have an MS Access 97 database that produces reports that mirror letters with the necessary fields. One of these fields is a series of values. I have created labels for the headings and text boxes for the body of the table. I would like to be able to make the labels invisible if there is no data in the first text boxes. I have tried this on the Report properties on the On Open procedure, but cannot get it to go. Any suggestions?

Thanks in Advance!

[Denburt]

Use the onFormat event, I use this for a number of reports for instance if my group totals are 0 then they are not visible for that group section but the next section they are. You can do the same thing for the detail section. Should work let me know.