Field on form set as memo type can not be edited after 2K characters

[kscheu via AccessMonster.com]

I have a form that updates a table. One field is bound to a memo field.
Users are getting an error once the text goes beyond approx. 2K - 3K. Before
that, the field works fine. Is there a limitation on editing a memo field
thru a form, and is there a work around?

Thanks.
Karen

 

[RuralGuy]

I have a form that updates a table. One field is bound to a memo field.
Users are getting an error once the text goes beyond approx. 2K - 3K. Before
that, the field works fine. Is there a limitation on editing a memo field
thru a form, and is there a work around?

Thanks.
Karen

Hi Karen,
What version of Access are you using and what control are you using to edit the
memo field?
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[kscheu via AccessMonster.com]

I am using Access 2003. I have a form that is bound to the table which
contains the memo field. The form is opened and the user can edit the memo
field which is a text box control that is bound to the memo field in the
table. I have a save button. See code below

The memo text box on the form is called txtOrderComments and is bound to
order_notes which is defined as a memo field in table t_comments_AR which is
the recordsource for the form FrmCommentsUpdateAR

Forms![FrmCommentsUpdateAR].Recordset.Edit
Forms![FrmCommentsUpdateAR]!LastUpdated = Date
Forms![FrmCommentsUpdateAR]!LastUser = strCurrentUser
Forms![FrmCommentsUpdateAR]!Contactid = Nz(Me.cboContact, 0)
Forms![FrmCommentsUpdateAR].Recordset.UPDATE
DoCmd.RunCommand acCmdSaveRecord

Thanks for your time and help.

I have a form that updates a table. One field is bound to a memo field.
Users are getting an error once the text goes beyond approx. 2K - 3K. Before

[quoted text clipped - 3 lines]

Thanks.
Karen

Hi Karen,
What version of Access are you using and what control are you using to edit the
memo field?
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[RuralGuy]

See notes in line:

I am using Access 2003. I have a form that is bound to the table which
contains the memo field. The form is opened and the user can edit the memo
field which is a text box control that is bound to the memo field in the
table. I have a save button. See code below

The memo text box on the form is called txtOrderComments and is bound to
order_notes which is defined as a memo field in table t_comments_AR which is
the recordsource for the form FrmCommentsUpdateAR

Are you aware of the fact that this record stamping can all be done in the
Form's BeforeUpdate event?

Forms![FrmCommentsUpdateAR].Recordset.Edit
Forms![FrmCommentsUpdateAR]!LastUpdated = Date
Forms![FrmCommentsUpdateAR]!LastUser = strCurrentUser
Forms![FrmCommentsUpdateAR]!Contactid = Nz(Me.cboContact, 0)
Forms![FrmCommentsUpdateAR].Recordset.UPDATE
DoCmd.RunCommand acCmdSaveRecord

Private Sub Form_BeforeUpdate(Cancel As Integer)

[LastUpdated] = Date
[LastUser] = strCurrentUser
[Contactid] = Nz(Me.cboContact, 0)

End Sub

Thanks for your time and help.

The help system for acXP states a TextBox can display 65,535 characters. I
doubt it was decreased in ac2k3. Look at specifications in Access help for that
answer.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[kscheu via AccessMonster.com]

Thanks for your help.

See notes in line:

I am using Access 2003. I have a form that is bound to the table which
contains the memo field. The form is opened and the user can edit the memo

[quoted text clipped - 4 lines]

order_notes which is defined as a memo field in table t_comments_AR which is
the recordsource for the form FrmCommentsUpdateAR

Are you aware of the fact that this record stamping can all be done in the
Form's BeforeUpdate event?

Forms![FrmCommentsUpdateAR].Recordset.Edit
Forms![FrmCommentsUpdateAR]!LastUpdated = Date
Forms![FrmCommentsUpdateAR]!LastUser = strCurrentUser
Forms![FrmCommentsUpdateAR]!Contactid = Nz(Me.cboContact, 0)
Forms![FrmCommentsUpdateAR].Recordset.UPDATE
DoCmd.RunCommand acCmdSaveRecord

Private Sub Form_BeforeUpdate(Cancel As Integer)

[LastUpdated] = Date
[LastUser] = strCurrentUser
[Contactid] = Nz(Me.cboContact, 0)

End Sub

Thanks for your time and help.

The help system for acXP states a TextBox can display 65,535 characters. I
doubt it was decreased in ac2k3. Look at specifications in Access help for that
answer.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.