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
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