Memo field suddenly lost half of entries

A

admin etc

Hi,

I have an access database which is used as a contact database for customers,
in the main data table we enter in the last contact information. it was
working fine until last week when all of a sudden over half the data
dissappeared and it set itself as a 50 character length and deleted anything
after this.

Any ideas as to how I can get the information back?
 
J

John W. Vinson

Hi,

I have an access database which is used as a contact database for customers,
in the main data table we enter in the last contact information. it was
working fine until last week when all of a sudden over half the data
dissappeared and it set itself as a 50 character length and deleted anything
after this.

Any ideas as to how I can get the information back?

Get out your backup :-{(

Someone must have changed the datatype from Memo to Text. Doublecheck the
table structure definition - if it's still memo, please post some more info.
 
A

admin etc

The datatype is still memo but the format field had the @ symbol and when I
remove that then I could add more data. Only problem is when I open the
backup they are the same with the missing data although the problem only
happened last week?????
 
J

John W. Vinson

The datatype is still memo but the format field had the @ symbol and when I
remove that then I could add more data. Only problem is when I open the
backup they are the same with the missing data although the problem only
happened last week?????

The *display* (not the actual content) of Memo fields will be trunctated if
you apply any Format. Solution: remove the Format. Your content should all
still be there.
 
F

Fred

One "sidebar" note.

Make sure you don't still have the data there, but "hidden" from the current
view (e.g. box) by line breaks.

do Shfit+F2
 
A

admin etc

I removed the @ symbol but all data was gone...

John W. Vinson said:
The *display* (not the actual content) of Memo fields will be trunctated if
you apply any Format. Solution: remove the Format. Your content should all
still be there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top