[AccessD] Unbound box question

Yup - that's different.

How about having two columns show when the dropdown list is selected?  The
left column will be the name, and the right column will say Active or
Inactive.  I do this to indicate if an employee is still employed or not.

Dan

-----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 4:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com