convert text characters to a symbol Kerryn 15.09.2006 03:04:02 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])

Re: convert text characters to a symbol "Al Campagna" <anon[ at ]anon.net> 15.09.2006 04:16:39 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) -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Kerryn" <Kerryn[ at ]discussions.microsoft.com> wrote in message news:978EE779-51B9-43A2-905E-B71C57F144AE[ at ]microsoft.com... [Quoted Text] >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])

Re: convert text characters to a symbol Marshall Barton <marshbarton[ at ]wowway.com> 15.09.2006 04:54:51 Kerryn wrote: [Quoted Text] >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. 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 -- Marsh MVP [MS Access]

Re: convert text characters to a symbol "Al Campagna" <anon[ at ]anon.net> 15.09.2006 13:42:16 Marshal, Hmmmm... CharMap for Arial on my system indicates Alt 0191 yields ¿ and 0189 yields ½ -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Marshall Barton" <marshbarton[ at ]wowway.com> wrote in message news:3oakg2l54mhgiit3402914p943rrsi79s9[ at ]4ax.com... [Quoted Text] > Kerryn wrote: > >>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. > > > 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 > > -- > Marsh > MVP [MS Access]

Re: convert text characters to a symbol Marshall Barton <marshbarton[ at ]wowway.com> 15.09.2006 14:05:29 Al Campagna wrote: [Quoted Text] >Marshal, > Hmmmm... CharMap for Arial on my system indicates Alt 0191 yields ¿ > and 0189 yields ½ Arrggghhh, copy/paste strikes again. Thanks for noting my mistake. -- Marsh MVP [MS Access]