|
Attn Geeks: MS Access help needed (conditional formatting)
|
View this Thread in Original format
| david.michael |
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
 |
|
|
| david.michael |
| I hate you all. |
|
|
| gehzumteufel |
| im sure bas knows. hes good at access db programming. |
|
|
| bas |
| Shouldn't it be [value]="Returned" ? |
|
|
| Nrg2Nfinit |
| quote: | Originally posted by bas
Shouldn't it be [value]="Returned" ? |
How many times have I told yuou, you cannot sell your mother |
|
|
| pitchf0rk |
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 |
|
|
|
|
