Exclude a character (Apostrophe) in an input field of a form

[Rich77]

In a form, an apostrophe may not be used in an input field (all other characters do not cause a problem). There are 2 options to solve this:
1. If the apostrophe is used, it will automatically be replaced by an underscore (with action "Replace").
2. If the apostrophe is used, a messagebox will warn you: "Apostrophe is not allowed" and you must first use another character.
I can't quite manage to implement either of these options without using a lot of VBA code.
Can anyone help me to solve this easily?

 

[Gasman]

Answered in your duplicate post.

 

[isladogs]

Crossposted at UtterAccess.com

 

[Gasman]

Cross posted at https://www.utteraccess.com/topics/2065565?post=unread

 

[Isaac]

check for the instr() of the char() or chr() value