Search a Locked text box in a form

G

Guest

I am working with a form and for safety reasons I needed to lock a text box.
Now I can no long perform a search of it. Is there a way to search a text box
one it is locked? If not I will have to unlock it and take my chances.

Thank you,
James
 
A

Allen Browne

Can you be a bit more specific here?

Perhaps you set the form's AllowEdits property to No, and you are trying to
enter a search value into an unbound text box and found it not possible? If
so, you need to leave AllowEdits as No, and set the Locked property of all
the bound controls instead, leaving the unbound box unlocked. There's some
code to do that in this article:
Locking bound controls on a form and subforms
at:
http://allenbrowne.com/ser-56.html

Or perhaps you set the Enabled property of the control to No, so you can't
put the cursor in there to use the Find dialog. If so, set Enabled back to
Yes, and set its Locked property to Yes instead.

Or, if you don't want to change the properties of the text box, you could
use this instead:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top