Apostrophes in List Boxes

[Terence]

Hello

I need to enter student names on a Form that contain
apostrophes. These names are then populated into a List
Box. The user then scan the names in the List Box to
populate all the data relating to that name on the Form.

When the user clicks on a name with an apostrophe, the
runtime error 3077 is produced.

Any help would be greatly appreciated.
Terence
London

 

[John Vinson]

Hello

I need to enter student names on a Form that contain
apostrophes. These names are then populated into a List
Box. The user then scan the names in the List Box to
populate all the data relating to that name on the Form.

When the user clicks on a name with an apostrophe, the
runtime error 3077 is produced.

Any help would be greatly appreciated.
Terence
London

It sounds like you have code to "populate" the listbox, and that
you're delimiting the names with ' marks. Change your code to use " as
a string delimiter instead and this error should go away. Post the VBA
code you're using if this isn't clear!