Depending on how you're using it, you may need to use % as the wildcard, not
*.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)



"JayTee" wrote in message
...
Hi all,
I am wondering if anyone out there knows why the wild card (*) will not
work in an MS Access 2010 query.

I tried, as I have for years, to enter a criteria in a query as follows:
Like "*" & [Forms]![FormName]![FieldName] & "*"
And it creates this
ALike "*" & [Forms]![FormName]![FieldName] & "*" and then won't work
Please help someone as I am at my wits end.
Thanks in advance

JayTee