Limiting memo field in form...

[strela]

Is it possible to limit memo field as textboxes are limited to certain
number of characters?
(I need memo with 660 characters - to fill box on already printed
formulary). Thanks in advance.

Best regards,
Stole.

 

[Allen Browne]

See:
Unbound text box: limiting entry length
at:
http://allenbrowne.com/ser-34.html

You can use the same approach with a text box bound to a Memo field.

 

[Svetlana]

I think you could do it like that

Private Sub txtMyMemo_KeyDown(KeyCode As Integer, Shift As Integer)
If Len(Me.txtMyMemo.Text) >= 660 Then
KeyCode = 0
End If
End Sub

 

[strela]

Thank you very much. Works perfectly, I just didn't have a time to check it
till now.

Best regards,
Stole.