FIND TEXT in Column

A

Andrew

Hi,
i have one db starting with the first column as CUSTNO. The following is the
same of the data in CUSTNO

CUSTNO
---------
#WATSONS
#GUARDIAN
#LOT10

when i press CTRL+F to search for the entired data in this DB, i cannot
trace it if the FIND item that i put is #WATSONS however i am manage to
search the position of the data if i JUST put WATSONS (Without #)

is there any reason why i failed to perform this? or i need to replace # to
another key? Please advice.

Regards,
Andrew
 
D

Dennis

I suggest you replace the # with some other character as Access uses the #
character to signify a date e.g. #28/03/2008#
 
Top