ACCESS 2010 vba question

[jscriptor09]

Hi folks

I am trying to figure out how to use wild characters in a rs search.

Set rs = db.OpenRecordset(strSQL)
Do While Not rs.EOF
If (Trim(rs![aField]) = I am lost Here) Then

What I am trying to do is to grab anything in "AField" that matches this:
1?C*
FC????G*


F????G*


Any idea how to structure this search?

Many thanks for any help

Mike

[jscriptor09]

If ((Trim(rs![aField] Like "1?C*") Or (Trim(rs![aFieldLike "FC????G*") Or (Trim(rs![aField]) Like "F????G*")) Then

Seems to do the right thing!