Memo field -> Maximum length

• baumgaertner

  Ten Centuries

  Points: 1344

  More actions

  October 13, 2008 at 3:32 am

  #72077

  Hello,

  I always thought, that Memo fields in Access are limited to 65.536 characters.

  But it seems not so.

  In my table I have an example with 89454 (The len() statement says so).

  What is the limit? How many characters can a memo field have?

  Thanks for your help.

  Regards,

  Daniel

• Chris Quinn-821458

  Hall of Fame

  Points: 3192

  More actions

  October 13, 2008 at 4:33 am

  #884057

  From Microsoft's Access specification(http://support.microsoft.com/kb/302524/en-us)

  Number of characters in a Memo field:

  65,535 when entering data through the user interface; 1 gigabyte of character storage when entering data programmatically

  This is probably due to the fact that a text box can only handle 65535 characters