Search a Locked text box in a form

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Similar Threads

Word Lock specific drop downs on a Word Document 0
Locking forms 9
combo box locked 4
Lock and Unlock a form 5
convert text box to combo box using vba 1
Locking a few field 2
Lock VBA 9
Locking Records 3 Months Old 4

Back
Top