Field Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Stammers - 14 Jan 2008 13:15 GMT

Hello,

I am using Word 2002 and I have a field that contains text and numbers. I
need the field to show as:

Gold Cover [£250,000]

however the pound sign seems to be corrupting and is showing as a strange
looking pipe character. The data in the field seems OK (it is an AS400
system). I have made sure that the regional setting in Word is set to English
UK. Is there anything I can do in formatting that will solve this?
Thanks,
Chris

Reply to this Message

Peter Jamieson - 14 Jan 2008 13:56 GMT

Assuming that the field can contain a "£" at any point, I can't think of a
way to deal with this in Word without either preprocessing your input or
postprocessing your output, unless you happen to have a font where this
particular "code point" displays correctly - and that would probably have to
be a non-Unicode font.

(AFAICS "£" is character A3 in Unicode but character 9C in, say the DOS USA
character set)

However, it is probably worth looking at your AS400 OLE DB provider/ODBC
driver to see if there is an option to do any character set translation.
"CCSID" is a keyword you could look for. (I think I've mentioned before that
I don't have an AS400 to play with here).

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hello,
>
[quoted text clipped - 10 lines]
> Thanks,
> Chris

Reply to this Message

Chris Stammers - 14 Jan 2008 14:13 GMT

Thanks for your help once again peter. I will check with our IT department.

Regards,
Chris

> Assuming that the field can contain a "£" at any point, I can't think of a
> way to deal with this in Word without either preprocessing your input or
[quoted text clipped - 24 lines]
> > Thanks,
> > Chris

Reply to this Message