combo boxes - does not recognise apostrophies

[dean]

i have a combo box based on fields in a table, if a field has a
apostrophie ( ' ) the the word, the combo box does not recognise.

any ideas how i overcome this please?

thank

 

[Ken Snell [MVP]]

Double up any embedded apostrophes using the Replace function. Post the Row
Source SQL statement for your combo box and we'll help you modify it.