Conditional formatting enabled field

[Carl]

I was able to make the conditional formatting work on a
field that I would like to change the back color of the
text box which works fine. I then need to make the text
box not enabled so that the user cannot enter anything if
they happen to click into the text box.

When the field is not enabled it has a default color
(grey) which is different from the one that I changed it
to and it also shows the underlying values which I was
trying to hide.

Is there anyway to change this default back color for a
text box which is not enabled?
I would like to make this text box not visible under
certain conditions but I dont think that is possible???

 

[Glenn]

Instead of disabling the field, lock it instead.
(See "Enabled, Locked Properties" in the VB help files")

This will prevent users changing the data, but preserve
your backgroung colour.

Rgds,
Glenn.

 

[PC Datasheet]

Carl,

Change the enabled property to No and the locked property to Yes. Users will not
be able to enter the control and your color scheme will work.

 

[Carl]

With Conditional formatting the lock field is not an
available property option?

 

[Carl]

I can't lock the field because it is conditional
formatting and I want the user to be able to enter data
into the field when it meets certain criteria and is
enabled and then it cant be locked. Locking a field is not
an option under conditional formatting as well as
visible....go figure?

 

[Glenn]

Sorry Carl,

You can't set the locked property to True with conditional
formatting, my mistake.

Glenn.