Input " Like A* " in Validation Rule Property but it shows " ALike "A*" " (1 Viewer)

Input " Like A* " in Validation Rule Property but it shows " ALike "A*" "

Hello
I've a problem that when I entered Like A* in the validation rule of an AgentID field (The purpose is to force the field to use A as the first character.),
the rule, however, showed ALike "A*". And when I added a record in the field, it didn't pass the validation rule even if I typed A as the first letter.
In addition, I have tried to enter the rule like this in my other access database files and got the same result.

How to get rid of A in ALike "A*" and pass the rule?
Thank you.

Re: Input " Like A* " in Validation Rule Property but it shows " ALike "A*" "

looking at the sample provided in your identical post here
http://www.accessforums.net/showthread.php?t=60432

you have set your db to use ANSI92 which uses Alike instead of Like.

And if you are using ANSI92 you use % rather than *

For the future, please advise when you are double posting so responders do not waste their time providing the same solutions - see this link for the reasons why

http://www.excelguru.ca/content.php?184

Re: Input " Like A* " in Validation Rule Property but it shows " ALike "A*" "

Thank you very much CJ_London and sorry for double posting!