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

I hate you all.

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

___________________

quote:

Originally posted by bas Dual exhaust tips on dual exhaust = QUAD EXHAUST = 300 gain in horsepower. Duh

quote:

Originally posted by bas Undies with a dickhole aren't good for guys. Your balls can get caught in them. That's why I prefer to go over the gate instead of through the fence.

EA(EXCELADDICT.COM)

___________________
ATB -Let u go
Iio - Rapture(riva edit)
Dj Encore - I see right through you
Lasgo - something

The best vocal tunes on LI RIP(2001-2002)

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

quote:

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

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

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