As * is a wildcard character that matches any string, it gives me the first row, not the first row containing an asterisks.
22 Answers
Enclosing the asterisk in your search string in square brackets, i.e. "[*]", is in fact the correct answer. This is according to Microsoft documentation. And here's the proof:
Works like a charm! Perhaps what you are missing is the "Any Part of Field" setting?
4Simple solution. Find and Replace will remove an asterisk in Access VER 14 in 2016 MS Office. Just use [*] in the find and nothing in the replace. Access takes anything in the brackets literally so it finds the character and doesn’t treat it like a wildcard. Also don’t put quotes around [*]
1
