Input Mask

[vanny]

Hope someone can suggest a way of how to go about this situation:

I have a Proforma Sub Form that has a Proforma No with input mask "PI"00/000;0 and then on the Proforma Form there is a combo box, used as a Search Facility for Proformas, having the same input mask "PI"00/000;0

The problem is that I would like that the user when he wants he can enter as well letters that is for example : PI00/000SUP. But obviously now if I change both input masks on Form and Sub Form, the other Proformas No stored as "PI"00/000;0 will not be compatible and thus will not allow me to search..

Any suggestions?!


Thanks a lot

 

[Tim L]

Could you change the way that the query being used to do the search is used? For example, use a wildcard at the end of the text being searched on.