[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