Memo field suddenly lost half of entries

  • Thread starter Thread starter admin etc
  • Start date Start date
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?
 
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?
Click to expand...

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.
 
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 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?????
Click to expand...

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.
 
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
 
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.
Click to expand...
 
Back
Top