MEMO FIELD QUESTION 1

[jadams0173]

I need to store some comments in a table. I thought of using the memo field type and then remembered it had some limitations such as not returning but the first 255 characters if used in a query in the group by section.

Is there an alternitive to this? I've thought of using multiple text fields and splitting the comments, but I have no idea how long the comments will be. Setting a defined length seems a little restrictive to me.

 

[fneily]

See:
Truncation of Memo fields

http://allenbrowne.com/ser-63.html

 

[jadams0173]

Thank you fneily!