Wildcards in VBA

[Elflord]

There is a lot on the internet about wildcards but I am trying to create a code line in VBA for Access which allows me to specify

If RTrim(txtECCN) = "EAR99" Then [txtExport] = "This is it as well"

Where EAR 99 can be replaced by EAR*

If I enter like before it in VBA it tells me that it is expecting an expression but generally doesn't like waht I do.

Any Help would be appreciated

Thanks