Attn Geeks: MS Access help needed (conditional formatting)

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Attn Geeks: MS Access help needed (conditional formatting)

Posted by david.michael on Feb-28-2008 18:13:

Attn Geeks: MS Access help needed (conditional formatting)

In a form, I have a drop down box called "Location". The items in the drop down box are Dayton, Columbus, Offsite, RETURNED, etc.

Basically, I want to set up conditional formatting so that when you select "RETURNED" in the drop-down box, it changes the formatting in other fields to be bolded/italicized.

I know you have to use "Expression Is" for the condition, but apparently I'm not getting the formula correct. I used

code:
[Location]="RETURNED"

No go. Can you not use an absolute value? Am I not on the right track here? Am I even making sense?

I'm using Access 2007 but saved in 2003 compatible format.

Edit: screenshot

Posted by david.michael on Feb-29-2008 18:48:

I hate you all.

Posted by gehzumteufel on Feb-29-2008 19:04:

im sure bas knows. hes good at access db programming.

Posted by Trancealot on Feb-29-2008 20:40:

EA(EXCELADDICT.COM)

Posted by bas on Mar-01-2008 02:33:

Shouldn't it be [value]="Returned" ?

Posted by Nrg2Nfinit on Mar-01-2008 02:36:

quote:
Originally posted by bas
Shouldn't it be [value]="Returned" ?

How many times have I told yuou, you cannot sell your mother

Posted by pitchf0rk on Mar-01-2008 11:52:

u gotta put the name of the field, not the textbox. so if your field name was "I_Caress_Small_Boys" for example, you would put [I_Caress_Small_Boys]="RETURNED" as the expression.

/Access programming skills