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

Properties panel vs. VB code

AccessIdiot
100+
P: 493
General question about order of events. If you set a property for a control (like a textbox) in the On Current event of the form but then you change the property using VBA does Access blow up?

How does Access handle a conflict like that? Does one side get over ruled by the other?

thanks
Mar 21 '07 #1
Share this Question
Share on Google+
4 Replies


Denburt
Expert 100+
P: 1,356
General question about order of events. If you set a property for a control (like a textbox) in the On Current event of the form but then you change the property using VBA does Access blow up?

How does Access handle a conflict like that? Does one side get over ruled by the other?

thanks

One would always go first the second one would generally rule.
Mar 21 '07 #2

AccessIdiot
100+
P: 493
thank you.
Mar 21 '07 #3

Denburt
Expert 100+
P: 1,356
thank you.

Your welcome and if you ever want to know how to blow up access I can give you at least a half dozen different ways right off the top of my head, many more that I know about but might have to give it a little more thought. LOL :)
Mar 21 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
When you first move to a record the property coded in the OnCurrent sub would be in effect until your other VBA code was executed.
Mar 21 '07 #5

Post your reply

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