Combo box crashes if text field has apostrophy (like O'Neil)

J

Jack Leitch

In Access, if I use a Combo box it crashes if text field has an apostrophy
(like the name O'Neil). Any suggestions?
 
M

Marshall Barton

Jack Leitch said:
In Access, if I use a Combo box it crashes if text field has an apostrophy
(like the name O'Neil).


"It" and "crashes" are not sufficiently specific to diagnose
a problem. If you have any VBA code associated with the
combo box, Copy/Paste it into your reply too.

In the meantime, try changing the query to use (two?) "
instead of '
 
Top