Can you limit the length of a memo field?

  • Thread starter Thread starter JimPNicholls
  • Start date Start date
J

JimPNicholls

Access 97

Hi. I would like to know whether you can limit the length
of a memo field and if so, how?

Text needs to be entered into the field but there will be
more than 255 characters so I can't use a text field. I
want to limit the entry to 1000 characters. Thanks
 
You might set the Validation Rule property of the field in your table to an
expression like this:

Is Null Or Len([Your Memo Field])<1000

This assumes your memo field is named "Your Memo Field" and you want to
allow null values (that is, the Required property is set to No).
 
Back
Top