By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,846 Members | 1,259 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,846 IT Pros & Developers. It's quick & easy.

Making a Label invisible

P: 3
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!
Aug 29 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,356
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.
Aug 29 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.