Asking Memo

[accessman2]

Hi,

I create the table, and fieldname,

What is the datatype, memo?

Datatype: Text
Fieldsize : 255 (max char)

Datatype: Memo

For the memo datatype, what is the size for that?
Is it unlimited size?

Please let me know, thanks.

 

[pbaldy]

The answer is in Access Help, under DataType Property.

 

[gemma-the-husky]

memo type holds 64000 characters, but note - you cannot sort it.

 

[pbaldy]

Actually according to A2k Help it's 65,535, but why not let the OP learn how to find things themselves?

 

[gemma-the-husky]

its funny - I assumed it ought to be 65535, but in A97 help it specifically says 64000 characters. Perhaps they meant 64K and it came out as 64000.