conditional formatting of fields turns off find/replace. Why?

[S J Ghosh]

I have a form with 20 fields in which users enter data. I conditionally
formatted them so that the fields are disabled when the data is entered.
Subsequently, the Find button on the form stops working. I get a message '
You cannot use Find/Replace Now. Why does this happen ?

 

[Steve Sanford]

Just to be precise, fields are in tables, controls are on forms.

So, you have 20 controls that are set to disabled after an entry is made in
the control. Lets say there are 5 buttons on a form and after you clicked on
a button, it is set to disabled. If I tell you 5 times "click a button", will
you ever try to click a button that you have already clicked? And if I tell
you a 6th time "click a button", what button will you click?

The FIND button does the same thing. If all 20 controls have had data
entered and are set to disabled, what is controls are available to search?

Access isn't installed on this computer, so I can't test anything. But maybe
you could set the controls to LOCKED instead of DISABLED. And maybe set the
background to a different color to indicate the control cannot be changed.


HTH