Community
Showing results for 
Search instead for 
Do you mean 
Reply

Max size of Memo Field

New Member
Posts: 3
Country: USA

Max size of Memo Field

Hello: Tech Support just told me that a Memo field can hold only 256 characters, but I can type more than that.  Does anyone know if there is a minimum # of characters/words?  I would like to add an unlimited text field (memo), but I hesitate...Thanks
Moderator
Posts: 4,395
Country: USA

Re: Max size of Memo Field

lhodge,

 

There isn't a character limit on memo fields.  For a quick test, I added 125,873 characters to a memo field.  Thats about a 60 page Word doc.

 

 

New Member
Posts: 3
Country: USA

Re: Max size of Memo Field

Thank you
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Max size of Memo Field

That information is really wrong. ACT! 6 did have a field size limit of 255 characters but the character field limit in 450 characters in ACT! 2008 and a memo field does not have any place to state a size. There likely is a maximum size for a memo field but it most cases it is effectively unlimited.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Max size of Memo Field

I think you'll find it's about 2,147,483,647 bytes - assuming it's a SQL text field (non-unicode) ... or about half that if ntext (unicode).