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

Set Visibility of Controls on Access Report in onOpen

P: 33
I'm running Access 2010, and I'm trying to set the visibility of a field when a report opens. The field is not affected by each individual record in the report, but rather by a value in a table that is not the source of the report.

What I'm trying to do is get the value when the report opens, and then set the visibility of a few controls based on that value.

I've been trying to use the OnOpen event and the OnLoad event, but the code isn't doing anything. This is not a security setting issue, as I have enabled the VBA to run.

Is there another event I can use to do this or am I doing this wrong somehow? I'm sure I'm missing something here...

Thank you!

~ServantOfOne~
May 2 '12 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,366
We would need to see the code.
May 2 '12 #2

P: 33
I will post something when I get to work. Thanks for the response.
May 2 '12 #3

NeoPa
Expert Mod 15k+
P: 31,494
The Report_Open() event should be fine. We'll need to see the code to be able to advise what you're doing wrong though ;-)
May 3 '12 #4

Post your reply

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