Wierd error when editing an Access Memo field.

[VRWC]

Hi folks,

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". The
message temporarily disappears. When the form refreshes, the text
reappears. Go figure!

Anyone have a clue why this is happening?

Many thanks for all responses.

[LWilson]

On Sat, 17 Jul 2004 18:36:04 -0500, VRWC <??@??.com> wrote:

Hi folks,

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". The
message temporarily disappears. When the form refreshes, the text
reappears. Go figure!

Anyone have a clue why this is happening?

Many thanks for all responses.

I get this too. It's tough to track down because it does not produce
an error number. When the following code executes in my similar form
all I get is a message box that says: 'Text too long to be edited."

=============== ==== BEGIN CODE =============== ============
Private Sub txtMsgBody_Mous eUp(Button As Integer, Shift As Integer, x
As Single, Y As Single)
On Error GoTo HandleErr

SP = Me.txtMsgBody.S elStart
sbMessage "Insert position = " & (SP + 1)

ExitHere:
Exit Sub
....

SP = a global variable used to capture the starting point of the
current edit cursor position.

Since the text box is bound to a memo field, I canot see why there
would be a problem with the length of the text unless it exceeded 64
MB. The only recodrs where I get this message are not over .5 MB in
length.

Hope someone knows what's going on here.

-- LW