How do you limit the memo field size to less than 64k chars? 1

[toefuzzies]

I have some memo fields where I would like the comments to be limited so people don't keep rambling on for pages and pages...

Does anyone know how to do that? I know that there is a fieldsize for the text type where you can limit the entry to 255 or less, but memo fields ?? I don't know if you can limit these, can you?

 

[LittleSmudge]

Do it elsewhere.

It is a lot easier to limit the amount of data in the text box control on the form. Then store that in a Memo field.

Eg Validation Rule
Len([controlName]) < 400

Or code in the BeforeUpdate event




'ope-that-'elps.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[toefuzzies]

Hey thanks, works like a charm!