If Statment

Hi,

I would like to know how to write if statements that includes "wildcards" for spaces. For example:

Please Login or Register  to view this content.

my problem is that if rs!Revision = "L" and Me.txtRev = "L " then the program would think that those two are not alike because of the space after the "L " in Me.txtRev and therefore it goes though the loop when I don't want it to.

Is there a way to have it something like this (I tried the code below and i know it doesn't work):

Please Login or Register  to view this content.

There is something wrong with this part of the code: " * & me.txtRev & * " and I don't know how to fix it.

Please help.

Thanks!

Check out "Like" in VBA help