Record find with special characters

[Khito]

When using the find and replace button, or the findrecord method, Access does
not find a match if the value contains the special character #

for example: searching for test #1 or test#1 will result in a "Search Item
not found" result.

 

[Maurice]

Khito,

Try placing your #-sign between brackets. That should do the job. So look for:

test [#] 1 or test[#]1 or test*[#] etc.

hth