Dan Waters
dwaters at usinternet.com
Thu Dec 23 09:48:01 CST 2004
Visibility is not one of the conditional formats, but color is. Using code for CF, you can change your control's color to whatever the background is. And, you'll also need to add code in the Enter or GotFocus event for that control to move the focus away if someone selects it or tabs into it. You're going uphill now . . . ! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen Sent: Thursday, December 23, 2004 9:27 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Code Behind Conditional Formatting And I want to make controls not visible if criteria is met. Oh boy, what fun it is to ride... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Thursday, December 23, 2004 10:12 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Code Behind Conditional Formatting Karen, The current Smart Access Newsletter has a good article about this: http://www.smartaccessnewsletter.com/ME2/Audiences/default.asp I haven't used code for conditional formatting, but I probably should for two reasons. Most importantly, for complex conditions, you can trap errors and step through the code to verify correctness. If you only use the conditional format screen, the screen simply displays whatever it can and errors can't be trapped. Guessing what went wrong gets pretty tedious. Secondly, the conditional format screen only allow 3 conditions. In code you can set up as many as you want. HTH, Dan Waters ProMation Systems -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen Sent: Thursday, December 23, 2004 8:38 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Code Behind Conditional Formatting Lebans doesn't do everything I need. In the meantime, I found this link which is interesting... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k 2/html/odc_conformat.asp -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Thursday, December 23, 2004 9:25 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Code Behind Conditional Formatting ..its built into A2K and above Karen but has limited functionality ...I find myself still using lebans conditional formatting functions (www.lebans.com) in most cases because it gives me absolute control and significantly more functionality. William Hindman ----- Original Message ----- From: "Nicholson, Karen" <cyx5 at cdc.gov> To: <accessd at databaseadvisors.com> Sent: Thursday, December 23, 2004 6:31 AM Subject: [AccessD] Code Behind Conditional Formatting Time check: 6:28 am. I am using conditional formatting (continuous forms) , a great little feature but it has its limitations. The code controlling the conditional formatting must be somewhere, but where? Wishing everyone of every religion, except certain grinches (and you know who you are) , a safe and happy holiday season. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com