Apostrophe in Combo Box

[cmw]

I have a combo box which displays the employee names from a table. Users
select an entry to "reassign" a unit of work to another individual. There are
several employees with apostrophies in their name. The name appears without
the apostrophe in the combo box, so when work is reassigned, it displays the
name differently than when updated from any other process. Example: Audit
trail updates show the individual as "O'Connor" but updates using the combo
box show "OConnor".

Is there any way, without using code to load the combox, to display the
correct name?

 

[fredg]

I have a combo box which displays the employee names from a table. Users
select an entry to "reassign" a unit of work to another individual. There are
several employees with apostrophies in their name. The name appears without
the apostrophe in the combo box, so when work is reassigned, it displays the
name differently than when updated from any other process. Example: Audit
trail updates show the individual as "O'Connor" but updates using the combo
box show "OConnor".

Is there any way, without using code to load the combox, to display the
correct name?

In a different newsgroup, it was requested that you post the Combo Box
rowsource.

Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

 

[cmw]

Ok, sorry, I didn't know which one to use.

In a different newsgroup, it was requested that you post the Combo Box
rowsource.

Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.