Can you limit the length of a memo field?

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
 
B

Brian Camire

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

memo field 7
Memo Field limit 3
Memo Field limiter 5
Memo vs. Text 255 8
appending more than 255 characters into a Memo field 13
corruption and memo fields 3
Access memo field problem/question 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top