Find a # character in access table

[Jerry C]

I have a Parts table and people have used the # sign in some of the part
numbers.
Example: # 12 Wire
How can I do a find on the part number field to find and replace the # sign?
When I do a find in the column using the # sign it is interpeted as finding
a number.

 

[fredg]

I have a Parts table and people have used the # sign in some of the part
numbers.
Example: # 12 Wire
How can I do a find on the part number field to find and replace the # sign?
When I do a find in the column using the # sign it is interpeted as finding
a number.

Surround the # with square brackets:
[#]