Apostrophe

[fernin8r]

I have a slight problem with the apostrophe. The user is to input a Project Number when creating a new project. This Project Number is used as a reference or link to many different things throught the database.

The problem occurs when the user inputs an apostrophe somewhere. I think it messes up my code because it acts as a comment mark.

MY QUESTION: Is there a way to detect an apostrophe within a Text Box so that i can notify the user that he/ she can't use an apostrophe?

Thanks

 

[RV]

Amongst others, try this:

Open the form in design mode.
Define this Validation Rule for your textbox:

Not Like "*'*"

Define a Validation Text

HTH,

RV

 

[mattbland]

or you could find the keyascii code for the apostrophe, so when pressed it brings up a msgbox??

 

[RV]

>or you could find the keyascii code for the apostrophe<

Which is 39, so you could use Chr(39)

RV