Apostrophes in List Boxes

  • Thread starter Thread starter Terence
  • Start date Start date
T

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
 
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
Click to expand...

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!
 
Back
Top