Limiting size of memo field

R

ranjith_newbie

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?
 
D

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.
 
Top