Re: Performing search on Text Box with an Input Mask

[RGALLEN]

Re: Performing search on Text Box with an Input Mask

I have a text box on a form which I want to place an input mask on except I have one problem. When I perform a search on the text box before I build an input mask the search works great. If I perform a search on the text box after I build the input mask it doesn't work. Here is waht my input mask looks like: 99\->a>a\-9999999\->a\-99;;
Is there anyone out there that can help me. I placed a message box in my code to see what I am receiving from the text box and found it isn't putting my litterals in the search. Here is an example of what I put in to search for and the results I receive.

Search criteria: 12-AD-1234567-W-12
Search results in MsgBox 12AD1234567W12

I hope I didn't confuse anyone. Your help would be greatly appreciated.

 

[Fizzio]

Try changing your mask to
99\->a>a\-9999999\->a\-99;0;

The 0 stipulates that literal characters are kept in. ;; or ;1; takes them out.

HTH