Limit memo field size

  • Thread starter Thread starter asnyder2721
  • Start date Start date
A

asnyder2721

Guest
Is there a way to limit the size of a memo field so the text entered does not scroll past the size of the field displayed on the form?
 
No built in feature that would allow that. Moreover this is something rather complicated to control programatically since you would have to foreseen and manage the many methos of updating a memo field (paste, etc).

Unless you go for a posteriori checking and warning (like checking for Len(Me.Controls("YourMemoControlName).Text) from the before update event of your memo control, and accordingly canceling the event and displaying a warning message ).

For more sophisitcated approach you will find example code at the Stephen Leban's Web site (great resource):
Limit Chars Memo

Implementation will require some tweaking though.
 

Users who are viewing this thread

Back
Top Bottom