Dan Waters
dwaters at usinternet.com
Thu Nov 20 09:51:05 CST 2008
Hi Rocky, You can set conditional formatting for multiple controls at one time. Select them all, then on the toolbar under Format, select Conditional Formatting. When you set this, all the controls' conditional formatting will be identical. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Thursday, November 20, 2008 9:30 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Conditional Formatting Dear List: I'm setting conditional formatting for a bunch of text boxes on a form - changing the background when the field has the focus. It's a very tedious job - one field at a time. Is there a way to automate this process? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com