Dan Waters
dwaters at usinternet.com
Wed Aug 6 17:37:01 CDT 2008
I'm using SP3, but it's not greyed out for me. -----Original Message----- "fixed" as in "neutered" or "spayed"? :-) Perhaps SP3 did this. I've not heard much that's good about SP3. Lambert -----Original Message----- I'm using Acess 2003/SP 3. Maybe it's been "fixed." -- Karen Rosenstiel Seattle WA USA -------------- Original message ---------------------- From: "Heenan, Lambert" <Lambert.Heenan at AIG.com> > ??? Works in Access 2002 with unbound forms. > > Lambert > > -----Original Message----- > > When I click on the unbound box to select it, the item "Conditional > Formatting" is grayed out on the menu???? > > -- > Karen Rosenstiel > Seattle WA USA > > -------------- Original message ---------------------- > From: "Heenan, Lambert" <Lambert.Heenan at AIG.com> > > Open you form in design mode and go to the Format menu. There you > > will find the magical world of 'Conditional Formatting' where what > > you want can be achieved with no code. > > > > Lambert > > > > -----Original Message----- > > > > I have the following behind an unbound box in a form (Yeah, I know. > > Don't Start!). I also have a checkbox field called Inactivated on > > the form. How could this be rewritten to have a record turn color > > (for example, light > > yellow) when Inactivated is checked? Can I even do that in an unbound box? > > > > SELECT tStaff.StaffID, [LastName] & IIf(IsNull([FirstName]),"",", " > > & > > [FirstName]) & " -- " & [LanierID] AS Staff FROM tStaff ORDER BY > > [LastName] & IIf(IsNull([FirstName]),"",", " & [FirstName]); > > > > TIA > > > > -- > > Karen Rosenstiel > > Seattle WA USA > > > > -- > > 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 > -- > 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