G Guest Sep 10, 2006 #1 In Access, if I use a Combo box it crashes if text field has an apostrophy (like the name O'Neil). Any suggestions?
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 Sep 10, 2006 #2 Jack Leitch said: In Access, if I use a Combo box it crashes if text field has an apostrophy (like the name O'Neil). Click to expand... "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 '
Jack Leitch said: In Access, if I use a Combo box it crashes if text field has an apostrophy (like the name O'Neil). Click to expand... "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 '