472,106 Members | 1,233 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,106 software developers and data experts.

Making a Label invisible

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
1 1970
1,356 Expert 1GB
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.

Similar topics

1 post views Thread by Susan van Houen | last post: by
8 posts views Thread by fayazmd | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.