How do I get an input mask work in searches?

[aabbbcc]

I have an input mask for the customers order in my database. 9999/15/01-00 gets to be seen this way when being entered. It is stored as 99991501 without the dashes.


On one of my forms, I have a search box. The users of the Database wanted to have the mask put on it as well. When I do that, the searches don't work.How do I get the mask work with the searches?

Thanks in advance for your kindly help.
It would be great if everyone could provide me any details.

 

[Galaxiom]

Use Replace() to remove the mask characters from what has typed in the search box then search with that.

One advantage of this technique is that the search will work either with or without the mask characters.

 

[aabbbcc]

but i have many customer order to search..
how could i write the VBA??
__________________________________________________________
Private Sub Form_Load()
Dim MyResult As String
MyResult = Replace("0000/00/00-00", "0000000000", "0000/00/00-00")
End Sub

__________________________________________________________

Am I RIGHT?

 

[aabbbcc]

i have another issue that the drop down box not showing the value the input mask. how could display the value of input mask in that drop down box???'