memo field size

[silversurfer]

memo field on my form does not allow or does not store more than a couple
hundred charcters. How can I get it to accept its 65,000 plus characters
field size?

 

[fredg]

memo field on my form does not allow or does not store more than a couple
hundred charcters. How can I get it to accept its 65,000 plus characters
field size?

You are mistaken.
A Memo datatype field can store 65000+ characters.
You must be using a Text datatype field, which stores only 255
characters.

 

[John Vinson]

memo field on my form does not allow or does not store more than a couple
hundred charcters. How can I get it to accept its 65,000 plus characters
field size?

The datatype in the Table (not anything on the form) is controlling.

Note that a Memo can hold 2 GBytes of data if loaded programmatically;
65536 bytes if it's typed in.

What *can* cause it to be truncated is: sorting by the memo field;
setting a Format property (on the field or on the form textbox); or
using the field in a UNION query or a Totals query. Check to be sure
you're not doing one of these.

John W. Vinson[MVP]

 

[Joe Butler]

Would this also cause memo fields to be truncated on a report? I have a memo
field that is truncating on a report. I'm using a Union query for the
report.

Joe

 

[John Vinson]

Would this also cause memo fields to be truncated on a report? I have a memo
field that is truncating on a report. I'm using a Union query for the
report.

That'll do it. Change it from UNION to UNION ALL.

John W. Vinson[MVP]

 

[MikeSweet]

I am having a similar problem. I have a field in my table that I set as Memo
but it only holds about as much as a text field with 255 characters. I can't
type more things into the field even at the table level.

 

[John W. Vinson]

I am having a similar problem. I have a field in my table that I set as Memo
but it only holds about as much as a text field with 255 characters. I can't
type more things into the field even at the table level.

Be sure that you are not specifying a Format (table, query or form) on
the field. Doing so will truncate the field to 255.


John W. Vinson [MVP]

 

[MikeSweet]

So even if I specify a ">" symbol for the format in the table?

 

[John W. Vinson]

So even if I specify a ">" symbol for the format in the table?

Yes, absolutely.

Why you would want a memo field in all caps is a mystery to me. Memos
are usually used for long narrative text, which is much harder to read
in all caps.

John W. Vinson [MVP]

 

[MikeSweet]

Thanks. I took it out. The caps were there because sometimes the person who
enters it randomly adds caps. Sometimes you have to work around people. I
don't know why ACCESS help or books that I have doesn't mention this
annoyance. But it is something that I will not forget.
Thanks for the quick response.

 

[MSACSNewb]

Thanks for this reply!
New to Access and this fixed my problem; the format for both the form and
the table was set to "@". I still haven't figured out what that is for but
removing it allows my field more than 255.
Thanks again!

 

[Heather]

Thank you. This solved my problem too. Thanks.

Thanks for this reply!
New to Access and this fixed my problem; the format for both the form and
the table was set to "@". I still haven't figured out what that is for but
removing it allows my field more than 255.
Thanks again!