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

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

 

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

Sorry, I'm new and posted this thread in the wrong forum.
I posted now in the Forms-forum.

 

[gemma-the-husky]

I would warn the user to avoid the apostrophe in the before update event of any text field.

The apostrophe is chr(39) so

If instr(fieldname, chr(39)) >0 then
Msgbox "Sorry. Apostrophe not allowed"
Cancel =true
Exit sub
End if

Sorry, it's chr(39)
Chr(34) is a double quote mark.

 

[Gasman]

Show what you have tried?
Why no ' ?
What if you have O'Brien?

 

[isladogs]

Crossposted with answer at UtterAccess.com

 

[Gasman]

Cross posted at https://www.utteraccess.com/topics/2065565?post=unread as well as the reported one here.

 

[Rich77]

I would warn the user to avoid the apostrophe in the before update event of any text field.

The apostrophe is chr(39) so

If instr(fieldname, chr(39)) >0 then
Msgbox "Sorry. Apostrophe not allowed"
Cancel =true
Exit sub
End if

Sorry, it's chr(39)
Chr(34) is a double quote mark.

Great, that's what I'm looking for.
Works fine, thanks,
Richard