Conditional Formating when control is locked

[Dale_Fye via AccessMonster.com]

I'm trying to setup a conditional format condition which will leave the
control with 3 formats

1. If the control has the focus, and is locked
2. If the control has the focus and is not locked
3. If the control doesn't have the focus

#2 and #3 are easy, but does anyone have any ideas how to setup the
formatting for #1?

 

[Ron2006]

Where are you putting the tests now?

single form? Continuous Form? Datasheet view?

Conditional formating control or in properties?

 

[Dale_Fye via AccessMonster.com]

Single form; using conditional formatting control; Access 2007

Intent is that as the user moves between controls they will get a visual
indication as to whether the control is locked, when it gets the focus.

Dale

 

[Ron2006]

This is one way:

Create a third conditional format test. Make it the last one because
once a condition is matched no further tests are made.

Select "Expression"
In the test area simply type True
Select the default formating that you want.

If neither of the first two conditions are met the third will
automatically be met and the formating will be envoked.


I have never tried it, but you may be able to simply format the
control to the desired default you want using the properties tab for
the control. and then the conditional formating may override that. May
be worth a try for a single form use form. This approach will NOT work
for a datasheet view which is what most of my uses have been (at least
not in 2003).

Ron