Re: Continuous Forms Formatting

David wrote:
I see a lot of posts about conditional formatting, but I'm not sure it can
handle what I am trying to do:

1. Field A is a date field. I want to do the following if Field A is
between 1/1/2007 and 12/31/2007
a. Check a check box and lock that check box after it is checked
b. Locked a bound text field
ELSE
a. Unlock the check box, allowing the user the option of checking it
b. Unlock the bound text field
c. Make the background of the text field pale yellow.

Can I do this with Conditional formatting, and if so, how?


On a continuous or data*** form, you need to use CF for
the color. But you have to use code like the others posted
to lock the controls/

--
Marsh
MVP [MS Access]
.