special characters display and print

[Fifty2One]

i need to display and print one of those "special characters" which is actually just an ampersand... but this would probably apply to lots of other special characters... anyhow one of my labels need to display and print
Description of Manufacturing &/or Processing Operations
and right now the ampersand is being replaced by - in the display and not printed at all...

 

[boblarson]

You have to use 2 Ampersands in a row to make it display one as using one Ampersand in a caption creates a hotkey.

So, use ... Manufacturing &&/or Processing... and you should be good.

 

[Fifty2One]

now that works perfectly!
how can other special characters be inserted like trade mark sign (153) or copyright (169) registered (174) and things like this?

 

[boblarson]

I'm assuming with the CHR() -

So, CHR(174) for instance.

 

[boblarson]

But, you probably have to set it in the form load event. If you try to use the CHR and type it in the properties, it will just display the literal of what you typed. But, if you use something like:

Me.txtMyTextBox.Caption = "Whatever you want " & Chr(189) & " and others"

 

[Fifty2One]

i tried it and typing CHR(174) resulted in displaying and printing
Description of Manufacturing &/or Processing Operations CHR(174)

... however a coworker just showed me how she gets the special characters into word docs so i tried it in access... it works! so i may as well share it...

go on start - all programs - accessories - system tools - character map
find the character and click on it
copy and paste it into the appropriate spot on the label in the access report

guess i was trying really hard to over think things... again...

 

[boblarson]

Yes, that jogged my memory too - When typing it directly out you can use the ALT+code number to type it in. So, if I want the character for 1/2 I can just type it by doing ALT+189 = ½

Sorry, brain wasn't working well this afternoon.

 

[keirnus]

Hello,

I searched the archives and found this thread.
Hope it's ok to bring it up again.

Anyway, about my problem in displaying special characters.
I can't display the Copyright char when making it a string in VB Editor.

lblCopyright.Caption = "Copyright " & Chr(169)

Result:

But if I directly copy and paste the Copyright character, it displays fine.

All OS Regional and Language Settings are in English
except for Location (Japan) in Regional Options tab and
the Language for non-Unicode Programs (Japanese) in
Advanced tab.

How to support the special characters in this setting?