-
I'm using VB6 and Access 97
I want to use wildcards to aid in my find
i.e *the*, etc.
The problem being is I cannot get it to work with a numerical field, so I cannot find on
*1*, 22*, etc. A straight forward find work okay find = 1. I can do any type of find with a text field though. I know you don't use the * for wildcards.
------------------
-
Try using single quotes around the search phrase. If you're looking for the number one, it would look like this. '1'
Feel free to email me if I need to explain further.
------------------
~John
