[AccessD] Changing colors on many controls on one Form

OMG, would you look at the dates on those.  I feel old all of a sudden.

I sure feel better knowing someone is listening!  ;-)

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R Mattys
Sent: Tuesday, January 09, 2007 6:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Changing colors on many controls on one Form

Yes, the answer is to use WithEvents

Take a look here:
http://www.databaseadvisors.com/newsletters.asp
First look at 'Preface to Tezt Box Class' and then 'Text Box Class'

I'm certain that there are a few people here who can answer any questions
you may have.

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message -----
From: <Johncliviger at aol.com>
To: <accessD at databaseadvisors.com>
Sent: Tuesday, January 09, 2007 5:58 AM
Subject: [AccessD] Changing colors on many controls on one Form


> Good morning all
>
> I've just been asked by a user if the backcolor can be changed when that
> control has got focus and changes back to original when it looses focus. 
> Yeah
> thats OK I can handle that no problems. But with 30+ controls going to 
> each
> control and adding one line of code to change the backcolor and change  it

> back
> on each got and lost focus property is a pain. And next week the  user 
> will ask
> "can we have a different color".
>
> This job labour intensive so is there a more elegant approach to this 
> simple
> but boring job??
>
> TIA
>
> johnc
> -- 
> 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