Dumb question on double quotes

C

CD Tom

I have some people the enter their names as Mary "M" Smith when this is
entered into the system it goes in fine but when I try and select it out it
gives me an error because of the "M". What's the best way to handle this type
of entry?
Thanks for any help.
Tom
 
L

Linq Adams via AccessMonster.com

Correct it when the user leaves the textbox, before it's saved:

Private Sub YourField_AfterUpdate()
Me.YourField = Replace(Me.YourField, Chr(34), "")
End Sub
 
Top