Limiting size of memo field

[Guest]

Id like to restrict the no. of characters entered in a memo field to a
maximum of about 1700-1800 characters. Is there any way to restrict the field
size of a memo field ? or is there any way to increase the field size of a
text field to about that much ie 1700-1800?

 

[Douglas J. Steele]

Assuming you're using a form for input purposes, you can put logic in the
text box's Key Press (or Key Down) event to check how many characters you've
got, and issue a warning.

There's really nothing you can do if you're not using a form, but then you
should never be updating tables directly.

 

[Van T. Dinh]

Try Stephen Lebans' Web site:

http://www.lebans.com/limitcharsmemo.htm

HTH
Van T. Dinh
MVP (Access)