Wierd error when editing an Access Memo field.

**LWilson** · Nov 13 '05, 02:06 AM

Re: Wierd error when editing an Access Memo field.

On Sat, 17 Jul 2004 18:36:04 -0500, VRWC <??@??.com> wrote:
[color=blue]
>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.[/color]

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

Wierd error when editing an Access Memo field.

Wierd error when editing an Access Memo field.

Comment