convert text characters to a symbol

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box in a report in access that displays a size 10 1/2 (Ten and
a half). I want to display the half as the "half symbol" to save space on a
very tight label. Does any one know how to do this please. I am using MS
Access 2002 Professional on a WinXp Operating System.

This is the text box
=Trim([NLabSize])
 
Kerryn,
In Arial Font, and many other fonts, the 1/2 symbol is Alt/0189 from the Keyboard, or
CHR(189) in code.
I don't know how you've stored the "1/2" value. You'll have to build a trap on the
report OnFormat event to recognize the 1/2 and convert it to ½.
"10" & Chr(189)
 
Kerryn said:
I have a text box in a report in access that displays a size 10 1/2 (Ten and
a half). I want to display the half as the "half symbol" to save space on a
very tight label. Does any one know how to do this please. I am using MS
Access 2002 Professional on a WinXp Operating System.
Click to expand...


Choose a font that includes that character (e.g. Arial).
Then, you can use Chr(191) in a text box expression:
="10 " & Chr(191)
Or you can type it directly into your label's Caption
property by holding down the Alt key and typing 0191
 
Marshal,
Hmmmm... CharMap for Arial on my system indicates Alt 0191 yields ¿
and 0189 yields ½
 
Al said:
Marshal,
Hmmmm... CharMap for Arial on my system indicates Alt 0191 yields ¿
and 0189 yields ½
Click to expand...


Arrggghhh, copy/paste strikes again.

Thanks for noting my mistake.
 
Back
Top