Change mask for a search button in form

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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]
 
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...
 
Back
Top