Closest match searches

[Sam Summers]

Hi,

I am trying to allow users to search for items by typing only the letters or numbers that they can read on an item into a text box in order to find all items that have the closest possible match.
The users input from the text box is used to open a viewing form that uses a query that refers to the input text box

i.e. Forms![ItemSearch]![inputBox].[Text]

So therefore if all that can be read on the item is :
(blank) R (blank) S1 (blank) 2 when the actual number is HRS112

How can I find all items that are close to this?

Can I use wildcards to fill in the blanks and if so how do I enter this expression in the search criteria of the Query?

I would be very grateful if someone could help me.

Thank you

 

[Sam Summers]

Sorry, somehow I posted this in the wrong place.

 

[Birdy]

In the text field for the search, try putting ?R?1?2 should bring back HRS112. Or you can use the * wild card. *112 will bring back HRS112 and everything els that ends with 112.

* Matches any number of characters. It can be used as the first or last character in the character string. wh* finds what, white, and why
? Matches any single alphabetic character. B?ll finds ball, bell, and bill
[ ] Matches any single character within the brackets. B[ae]ll finds ball and bell but not bill
! Matches any character not in the brackets. b[!ae]ll finds bill and bull but not bell
- Matches any one of a range of characters. You must specify the range in ascending order (A to Z, not Z to A). b[a-c]d finds bad, bbd, and bcd
# Matches any single numeric character. 1#3 finds 103, 113, 123