[AccessD] Code Behind Conditional Formatting

Dan Waters dwaters at usinternet.com
Thu Dec 23 09:12:02 CST 2004


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




More information about the AccessD mailing list