[AccessD] Code Behind Conditional Formatting

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




More information about the AccessD mailing list