Memo field suddenly lost half of entries

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?

On Tue, 23 Mar 2010 22:37:01 -0700, admin etc
wrote:

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.
--

John W. Vinson [MVP]

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?????

"John W. Vinson" wrote:

On Tue, 23 Mar 2010 22:37:01 -0700, admin etc
wrote:

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.
--

John W. Vinson [MVP]
.

On Wed, 24 Mar 2010 01:56:01 -0700, admin etc
wrote:

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.
--

John W. Vinson [MVP]

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" wrote:

On Wed, 24 Mar 2010 01:56:01 -0700, admin etc
wrote:

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.
--

John W. Vinson [MVP]
.

Where do I do the "shift+F2" in data view or design view??

"Fred" wrote:

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