Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Tue Feb 3 17:52:50 CST 2009
Expression is [archive]=True (where archive is a yes/no field. When expression is True, back color is set to gray. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Tuesday, February 03, 2009 1:07 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Conditional Formatting Rocky, if you're using a loop, check the object type -- maybe it's just skipping those controls because they're not part of the conditional type or name. Oh wait... you're using the building in formatting, right? Share the expressions/conditions, etc. with us. Susan H. > Dear List: > > I am using conditional formatting on a continuous form to set the > background color to gray if [Archive] = True. Where Archive is a > Yes/No field in the underlying recordset. > > Works fine on all text fields and combo boxes on the form. > > Except for 4 text boxes that refuse to change their background color. > I can't see any difference between this set of four and all the > others. But I'm sure there must be. And I'm just not seeing it. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com