How to add "&" in dropdown

[C''''est_moi]

Hi everybody:
I seem to have a bit of a problem (again...). I have a DD with the name of
several entities users must choose from when filling a form. One of the
entity is "xxx & yyy". The "&" is part of the legal name so it MUST stay as
is (ie I cannot change to "and").

I inserted the name in the DD which reads fine with the "&" but the "&" does
not show on screen nor on paper when I print. Is anyone familiar with this
situation?

If there is no quick solution, I'll just insert the name in the DD up to but
excluding the "&" and then write an "if" command after the DD field that will
update the name when user chooses it but I would rather have the entire name
in the DD of course.

Thx for your help again.
Carmen

 

[Jay Freedman]

See http://gregmaxey.mvps.org/Use_Ampersand_in_Dropdown_Field.htm for a
workaround.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Simon Lloyd]

If you are populating your dropdown using vba then you can use somethng
like: "xxx " & Chr(38) & " yyy" as the ASCii charcter 38 is &.

Hope that helps!

Hi everybody:
I seem to have a bit of a problem (again...). I have a DD with the name
of
several entities users must choose from when filling a form. One of the
entity is "xxx & yyy". The "&" is part of the legal name so it MUST
stay as
is (ie I cannot change to "and").

I inserted the name in the DD which reads fine with the "&" but the "&"
does
not show on screen nor on paper when I print. Is anyone familiar with
this
situation?

If there is no quick solution, I'll just insert the name in the DD up
to but
excluding the "&" and then write an "if" command after the DD field
that will
update the name when user chooses it but I would rather have the entire
name
in the DD of course.

Thx for your help again.
Carmen

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[C''''est_moi]

Wow. Thank you so very much Jay and to you Greg as well for that article.
That works wonderfully. And it solves at the same time the problem of the
entities that are longer than 50 characters, thus do not fit in a DD. Didn't
even have to program an "if" field after the DD nor below in the
cross-references. Everything updates itself to the proper name. I just have
to add the proper name at length under the appropriate case. Double Wow.

Thx so much and merci as well.
Carmen