Sorry I've had to post this again, someone replied but my message has disappeared.

I've got VB6 and Access97.
I want to find using wildcards. I can do it no problem with text fields, but cannot get it to work with numerical fields
i.e. Refno= any number that contains 12 ,etc

I've tried .Find "Refno LIKE %" & txtFields & "%" and I've replaced the % with * but makes no difference. I can do a straight forward find Refno=12 no problem. I've even tried enclosing them in ' but still doesn't work.

------------------