>>Since the maximum positive signed integer is 2 gb, any value larger couldn't be correctly interpreted. If someone has information different from this, I'd appreciate their pointing me towards the source.
>
>George;
>
>From the MSDN Library under "memo field type": “Memo fields are limited only by the amount of available disk space.” Interesting… I truly thought there was a 2 gig limit to a memo field. Does anyone have a more in depth analysis? Otherwise we have to use our faith to believe this statement. Being named Thomas does allow me to ask questions!
>
Tom,

< g >

I wonder how current that information is. The only reason I mention this is the size of the memo field in the designer (4 bytes). There are two possibilities: It's the pointer to the memo block (the block number if you will); or it's the offset of the block into the memo file. I've always thought it was the latter. However, I did a silly thing and didn't RTFM before I posted the previous.< g > It's the block number, "The table file contains block numbers that are used to reference the memo blocks" (from the docs).:-)