Language changes after update query

Y

Y2

I have a data entry form where the user fills out text, numerical data,
dates, etc. I created a button in the same form that runs a macro in
background containing several update queries. At least 1 record changes from
English to some other kind of language or font but it looks like Japanese or
Chinese characters. I can't figure out why this happens and only on the that
1 macro. I would very much appreciate your input. TIA
 
J

John W. Vinson

I have a data entry form where the user fills out text, numerical data,
dates, etc. I created a button in the same form that runs a macro in
background containing several update queries. At least 1 record changes from
English to some other kind of language or font but it looks like Japanese or
Chinese characters. I can't figure out why this happens and only on the that
1 macro. I would very much appreciate your input. TIA
Click to expand...

This very strongly suggests that you have database corruption. Is there a Memo
field in the table? Could you post the steps of the macro and the SQL of any
update query which updates this table?

Do review Tony's corruption FAQ below... and *make a backup of your database*,
it may be in for some trouble.

http://www.granite.ab.ca/access/corruptmdbs.htm
 
Top