Limiting Memo Field Size

[DBQueen]

How can I limit the size of a Memo field? I don't want the user to be able
to enter more than 500 characters.

Thanks!

Andi

[hbinc]

Hi DBQueen,

Try:

Private Sub ThisMemo_BeforeUpdate(Cancel As Integer)
If (Len(ThisMemo) 500) Then
MsgBox "Memo is too long. Reduce to 500 characters"
Cancel = True
End If
End Sub
HBInc.
DBQueen wrote:

How can I limit the size of a Memo field? I don't want the user to be able
to enter more than 500 characters.

Thanks!

Andi

[pietlinden]

DBQueen wrote:

How can I limit the size of a Memo field? I don't want the user to be able
to enter more than 500 characters.

Thanks!

Andi

It's a bit more complicated than using BeforeUpdate... fortunately,
Allen Browne sorted it out for everyone... (thanks Allen!... I would
have been forever working on that!)

http://www.allenbrowne.com/ser-34.html

[hbinc]

Hi,

The complication is only when you want to stop input after the 500th
character.
In that case you're right.
In the case you want to limit the amount of text in a Memo field to
500, there is this less formal approach with ThisMemo_Before_update, in
which the user of the Memo field can reduce his remark to 500
characters or less.

HBInc.

pi********@hotmail.com wrote:

DBQueen wrote:

How can I limit the size of a Memo field? I don't want the user to be able
to enter more than 500 characters.

Thanks!

Andi

It's a bit more complicated than using BeforeUpdate... fortunately,
Allen Browne sorted it out for everyone... (thanks Allen!... I would
have been forever working on that!)

http://www.allenbrowne.com/ser-34.html