Lost data in Memo field

[Sam]

Help!! I am using MSAcces 2000 with a split database.
The backend is the only thing on a dedicated pc.

Occasionally my users tell me they have lost data that
they entered in a Memo field. I have a form for d/e with
5 tabs. the first tab is a memo field that holds
important data that they need to see when the form opens --
-and it is the one they claim that data gets erased/lost.

I am doing backups at noon and at night to try and 'find'
the data - but so far have not.

Any ideas on how I can solve this. Should I do backups
more often? Is this a problem with Memo fields? I had a
similiar problem 6 years ago but it was when I had the
backend on the pc that housed the 'net --- adn had a lot
of activity between that pc and the others, one or two
lines in that memo field would show xxxx --when I changed
it to a dedicated pc, the problem disappeared.

Would appreciate any help. Happy Holidays. Susan

 

[Joseph Meehan]

When you say you try to "find" the data, or they say they "lost" it, are
you trying to use the "Find" feature? If so be aware that it can only
search the first 255 characters. I might also suggest that I and some
others have had problems with memo fields becoming corrupted. I will not us
them in critical applications any more.

 

[Jim/Chris]

I have had this problem. What I discovered was that the
problem was with the Access default for a memo field. When
the memo filed is clicked with the mouse the entire text
that has been typed is selected. Typing any key or hitting
the space bar erases the previous text. I put this code in
the "OnEnter" event of the Memo filed.

Me!Memofieldname.SelStart = Me!memofieldname.SelStart

This deselects the text and places the cursor at the
beginning of the text field.

Jim


' Set's cursor to the beginning

 

[Sam]

Hi. By 'find' I mean I go into the table and scroll
through the memo field (in one of my backups).

If you need to be able to have the users enter a
continual amount of data (adding to a comments section
everytime a user deals with a client) -- how do you store
this data if not with a memo field? I do not know SQL -
and have created this entire system 6 yrs ago without it --
so any help you can give me, that I can apply without
knowing astual coding -- would be such a help. I will be
doing a major rewrite early next year. thanks so much.

 

[sam]

thank you. I do not know SQL -- but have seen the
OnEnter command in my macro's (or is it the property).
Could you tell me in a little more detail how to insert
this code and where. Was this is a solution for this
problem? again, thanks.

 

[=?EUC-KR?B?wMywx7/r?=]

thank you. I do not know SQL -- but have seen the
OnEnter command in my macro's (or is it the property).
Could you tell me in a little more detail how to insert
this code and where. Was this is a solution for this
problem? again, thanks.

 

[Joseph Meehan]

In my applications the 255 character limit of a text (not memo) filed
works. The users do not have many contacts with the same taxpayer and the
notes made for each are generally short. As it has turned out the limit has
taught them to be less wordy and the results are more usable.

If more room was needed I would tend to go for a linked table for the
comments. Maybe one record per contact. That might even organize the
results better anyway.