I've seen similar things with memo fields on reports and forms in which I had to substring to 255 and concatenate back together.
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Information Technology
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 2, 2018 11:37 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Long text field returning Japanese script
James - That indicates corruption. Try compacting the database. If that doesn't help import everything into a new, blank database.
If none of the above fixes your problem you will have to dig down in the macros to find the cause. What is the source of the data?
Sorry for not being able to offer a direct fix, but there are so many places where something like this can go wrong.
---In MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>, <asanteza@gmail.com<mailto:asanteza@gmail.com>> wrote :
I have a table that is cleared and appended using macros. Unfortunately, the long text field is returning something like Japanese script. I have recreated the table but does not solve the problem.
Please help.
James
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar