[AccessD] Changing colors on many controls on one Form

Same here. I wasn't aware of your site features.
I'll be looking into that ASAP.

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

----- Original Message ----- 
From: "JWColby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, January 09, 2007 6:49 AM
Subject: Re: [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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com