F
Frank Olynyk
Two systems that I have built have had this problem. A table containing only
a single record used as 'memory' for the system (the form(s) it is based on
have "do not add" and "do not delete" set) has a number of text and numeric
(long integer) fields. After running several buttons on the form (or forms)
I discover that the displayed characters have changed from my original values
to Chinese characters. I assume this means that the field is now being
interpreted as Unicode. As near as I can tell it is displaying half as many
characters as I originally put in the field. It would appear that all text
fields change (if they are not null). Most of these fields are only edited
manually; some may be changed during the course of running the several/many
buttons and forms which define the system. These buttons can execute
queries, or can contain code that manipulates tables through the
Openrecordset or runsql methods.
Has anyone else seen this behavior? Does anyone know what causes it, and in
particular, how to prevent it?
Thanks for any help.
Frank.
a single record used as 'memory' for the system (the form(s) it is based on
have "do not add" and "do not delete" set) has a number of text and numeric
(long integer) fields. After running several buttons on the form (or forms)
I discover that the displayed characters have changed from my original values
to Chinese characters. I assume this means that the field is now being
interpreted as Unicode. As near as I can tell it is displaying half as many
characters as I originally put in the field. It would appear that all text
fields change (if they are not null). Most of these fields are only edited
manually; some may be changed during the course of running the several/many
buttons and forms which define the system. These buttons can execute
queries, or can contain code that manipulates tables through the
Openrecordset or runsql methods.
Has anyone else seen this behavior? Does anyone know what causes it, and in
particular, how to prevent it?
Thanks for any help.
Frank.