[AccessD] Unbound box question

krosenstiel at comcast.net krosenstiel at comcast.net
Wed Aug 6 14:45:54 CDT 2008


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-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> krosenstiel at comcast.net
> Sent: Wednesday, August 06, 2008 3:04 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Unbound box question
> 
> 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




More information about the AccessD mailing list