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

Form Re-load

P: 121

I have a form that uses conditional formatting on controls so a txt box will change colour if a value is met.

I want to be able to "re-load" the form without having to close and re-open it

So that it returns to the state of when it is first opened

Any help is much appreciated

Regards Phill
Aug 4 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,287
Conditional formatting is applied as soon as the Value of the control changes, so no need to reload anything. If you want, you can set initial values for your controls in the Form_Open event, and you can later just call Form_Open and have them reset.
Aug 4 '09 #2

P: 121
Thanks ChipR I will try it

regards Phill
Aug 6 '09 #3

Post your reply

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