Conditional formatting enabled field

  • Thread starter Thread starter Carl
  • Start date Start date
C

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???
 
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.
 
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.
 
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?
 
Sorry Carl,

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

Glenn.
 
Back
Top