>Hello:
>
>I'm working on a search screen that searches on various criteria
>and I'm getting an error when someone enters in an apostraphe
>in the surname i,e, O'leary
>
>How can I force then either not to enter the apostraphe
>or if they do give them an error message.
>
>I'm using the following code:
>
>str3=""
>
>If not empty(this.value)
>str3 = "upper(client.surname) like '" + allt(upper(this.value)) + "%'"
>Endif
>
>If left(str3,2) = "'"
>=messagebox("you cannot enter an apostraphe, please enter the first letter of last name", 48, "CATS")
>
>Any help would be appreciated.
> Thank you.

Just out of curiousity, what error are you getting? I can see where a quotation mark would generate one, but not an apostrophe unless you're concatenting a string and using it as a delimiter for literals.