If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record find with special characters
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. |
#2
|
|||
|
|||
Record find with special characters
Khito,
Try placing your #-sign between brackets. That should do the job. So look for: test [#] 1 or test[#]1 or test*[#] etc. hth -- Maurice Ausum "Khito" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|