K
knawtn via AccessMonster.com
Hello.
I have a table containing accident report data. One field, AccDet, is a memo
field for accident description/details, and can be as many as 1000 characters
in length. I have a form, tied to the table, where this data is filled in. No
problem........until I close the form and open the table. The memo field has
the first 500 +- characters accurate...then some kind of weird symbolic code-
gibberish-gooble-d-glop replacing the last part of the memo field.
I also created an edit form, based on a query that is based on the table.
When I choose the questionable record, it displays in the same manner on my
edit form. However, when I replace the garble-splop with the correct text, it
saves fine (from the edit form).
Fortunately, I have only just begun. Only 4 records of test data thus far.
Already compacted (Access 2003). Already re-created and imported. Same
results.
DB sits on a network share, but has only been used by me so far.
Strange one. Any help?
I have a table containing accident report data. One field, AccDet, is a memo
field for accident description/details, and can be as many as 1000 characters
in length. I have a form, tied to the table, where this data is filled in. No
problem........until I close the form and open the table. The memo field has
the first 500 +- characters accurate...then some kind of weird symbolic code-
gibberish-gooble-d-glop replacing the last part of the memo field.
I also created an edit form, based on a query that is based on the table.
When I choose the questionable record, it displays in the same manner on my
edit form. However, when I replace the garble-splop with the correct text, it
saves fine (from the edit form).
Fortunately, I have only just begun. Only 4 records of test data thus far.
Already compacted (Access 2003). Already re-created and imported. Same
results.
DB sits on a network share, but has only been used by me so far.
Strange one. Any help?