Anne Lee wrote:
While translating a huge table in Access, I have placed symbols like * and ? next to the terms I wanted to check later. Now I find that the search function does not seem to recognise those symbols.
This happens because * and ? are wildcard characters, i.e. they have the following meaning:
* = Matches any number of characters. It can be used as the first or last character in the character string.
Example: wh* finds what, white, and why
? = Matches any single alphabetic character.
Example: B?ll finds ball, bell, and bill
You should have used something different (not a wildcard),
for example @@@, or ~~~.
From the Access Help System
When using wildcard characters to search for an asterisk (*), question mark (?), number sign (#), opening bracket ([), or hyphen (-), you must enclose the item you're searching for in brackets.
For example, to search for a question mark, type [?] in the Find dialog box. If you're searching for a hyphen and other characters simultaneously, place the hyphen before or after all the other characters inside the brackets. (However, if you have an exclamation point (!) after the opening bracket, place the hyphen after the exclamation point.) If you're searching for an exclamation point (!) or closing bracket (]), you don't need to enclose it in brackets.
You can find more details in the Access help system.
[Edited at 2004-01-23 11:26]