Change mask for a search button in form

G

Guest

I have a search button on the top of my form. When I click it, it comes up
with the Find dialog box and I can enter SSN and it will find a record. Is
there a way that I can enter an input mask or anything so I don't have to put
the hyphens in the SSN?? It's a pain. Do you have a better way to have a
search button?
 
J

John Vinson

I have a search button on the top of my form. When I click it, it comes up
with the Find dialog box and I can enter SSN and it will find a record. Is
there a way that I can enter an input mask or anything so I don't have to put
the hyphens in the SSN?? It's a pain. Do you have a better way to have a
search button?
Click to expand...

I'd suggest using a Combo Box, using the "Use this combo to find a
record" toolbox wizard option. This will allow you to pick only
existing SSN's, and it will autocomplete - much simpler for the users!

No, you cannot use masks or formatting in an Input Box, only in form
controls.

John W. Vinson[MVP]
 
G

Guest

Thank you, John! That worked perfectly! :)

John Vinson said:
I'd suggest using a Combo Box, using the "Use this combo to find a
record" toolbox wizard option. This will allow you to pick only
existing SSN's, and it will autocomplete - much simpler for the users!

No, you cannot use masks or formatting in an Input Box, only in form
controls.

John W. Vinson[MVP]
Click to expand...
 

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

Show Button 3
Search form 0
null value in an input masked field 3
Hide allbut last four characters of a social security number 1
Input Mask Help 1
Date Input Mask Question 4
Record Search within a Form 3
Formatting a Combo box 12

Top