[AccessD] Unbound box question

"fixed" as in "neutered" or "spayed"? :-)

Perhaps SP3 did this. I've not heard much that's good about SP3.

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 5:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Unbound box question

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-----
> 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:46 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Unbound box question
> 
> 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
> 
> --
> 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