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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access, if I use a Combo box it crashes if text field has an apostrophy
(like the name O'Neil). Any suggestions?
 
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 '
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Build PL/SQL Statement with VBA 2
Find Record 5
Display error in distribution file but not development file?!?!? 10
stLinkCriteria with field that has a quote 2
Update Method 1
How do I add an apostrophy to a range of existing cells? 3
Bargain FAO Sir Flopps 3
Correct formating for columns with numbers such as 01, 02, 03 etc 2

Back
Top