[AccessD] Unbound box question

I was hoping for a color highlight in the unbound list box, which is the index for the database, to tag the inactive staff in an obvious way so that they can be skipped, if the user doesn't really want to see their records.

Thanks anyway though. 

--
Karen Rosenstiel
Seattle WA USA

 -------------- Original message ----------------------
From: "Dan Waters" <dwaters at usinternet.com>
> Ummm.  I haven't had good luck using conditional formatting in unbound
> controls.  Seems to work sometimes and not others - don't know why.
> 
> How about just changing the backcolor of the control based the value of the
> checkbox?
> 
> 	If chkInactivate = true then
> 		cboList.BackColor = 'Yellow'
> 	else
> 		cboList.BackColor = 'White'
> 	endif
> 
> Put this code into any appropriate events - and you'll need to figure out
> what numbers correspond to the colors you want.
> 
> Dan
> 
> -----Original Message-----
> 
> 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