Please Help! A2K memo field shows eror "Too much text to edit"

Hope someone has some insight to this problem.

I have a form that contains a large (5" x 4") text box bound to a memo
field. This field allows users to type in the text of an email to be
sent through Outlook (via automation). I ONE user who send me his
back end data base where he has inserted several two - three page
emails. When scrolling through the records, two of about twenty
records shows and error that says "Too much text to edit". This error
occurs when the cursor is placed inside the text box that is connected
to the memo field. After the error appears, the text temporarily
disappears. When the form refreshes, the text reappears. Go figure!

I DO have VBA code in the "On Enter" event that checks the cursor
position inside the text box. Disabling this code does not cure the
problem.

BTW -- according to Microsoft, up to 64 MEGABYTES of text can be
stored in a single record memo field. I assure you our entries in
this field are nowhere NEAR that amount.

Anyone have a clue why this is happening?

Many thanks for all responses.

Try commenting out the whole code module by placing #IF FALSE THEN at the
start, and #ENDIF at the end. (Remember the crosshatches!) Then you can be
confident that *none* of the code is causing it.

HTH,
TC


"Lauren Wilson" wrote in message
...
Hope someone has some insight to this problem.

I have a form that contains a large (5" x 4") text box bound to a memo
field. This field allows users to type in the text of an email to be
sent through Outlook (via automation). I ONE user who send me his
back end data base where he has inserted several two - three page
emails. When scrolling through the records, two of about twenty
records shows and error that says "Too much text to edit". This error
occurs when the cursor is placed inside the text box that is connected
to the memo field. After the error appears, the text temporarily
disappears. When the form refreshes, the text reappears. Go figure!

I DO have VBA code in the "On Enter" event that checks the cursor
position inside the text box. Disabling this code does not cure the
problem.

BTW -- according to Microsoft, up to 64 MEGABYTES of text can be
stored in a single record memo field. I assure you our entries in
this field are nowhere NEAR that amount.

Anyone have a clue why this is happening?

Many thanks for all responses.