ACCESS 2003 memo field/data type will only hold 255 Characters why

[Guest]

when I use the memo data type in my tables the field will not hold more than
255 characters. Why? I thought the purpose of this data type was to hold
64000 characters.

 

[Albert D.Kallal]

The memo field certainly holds much more then 255 chars.

Are you able to enter the data..but experience a cut off in reporting etc?

Try removing any, and all formatting of the memo field on your form. (and,
also for any queries etc also).

 

[Guest]

I have this problem even when I open the table and enter data directly into
the field. Is there some switch or parameter in Access that I need to
activate?

 

[Rick Brandt]

I have this problem even when I open the table and enter data
directly into the field. Is there some switch or parameter in Access
that I need to activate?

Do you have any formatting on the field in the table definition? Remove it
if you do.

Also validation rules and inputmasks.

 

[Albert D.Kallal]

I have this problem even when I open the table and enter data directly into
the field. Is there some switch or parameter in Access that I need to
activate?

Either that field is NOT a memo type field, or as mentioned, you want to
remove any input masks, or formatting masks.

So, check the data type of the field, either you got it wrong (it is not
type memo), or you got some masking stuff here...