Darren DICK
darrend at nimble.com.au
Tue Jan 9 18:16:04 CST 2007
Hi John I have a cheats way - no code- way cool Just to test this - pick just one control from your form Set its back colour to say...red then save the form Then change the back colour for that very same control to transparent and save the form Then open the form in run time Watch what happens when that control receives the focus then looses the focus Not too sure if this works for a97 - it works (as far as I can recall) for A2K and AXP Hope this helps See ya Darren ------------------ T: 0424 696 433 -----Original Message----- From: Johncliviger at aol.com [mailto:Johncliviger at aol.com] Sent: Tuesday, 9 January 2007 9:58 PM To: accessD at databaseadvisors.com 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