I am linking to a Lotus Approach (dbf) file that contains fields with
the ½ character.  The font used in Lotus Approach is simply the Arial
font.  Nothing special.  However, in Access, the ½ character displays
as ╜.  Interestingly enough, the ½ character can be created using ALT
+0189 on the keyboard, where ╜can be created using alt+189, if this
sheds any light.

I have attempted to change the font settings in the Options for
datasheets but without any success.

The real problem is that when I connect to this Access database using
a web service and transfer data from the linked tables to my PocketPC
application, the ½ character does not transfer correctly.  However, if
I enter the ½ character into a native access table, the ½ character
displays fine in Access and transfers and displays just fine to my
PocketPC application.

So, how do I get the ½ character in the linked Lotus Approach table to
display correctly in Access?

Sean M. Severson