memo field size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

You are mistaken.
A Memo datatype field can store 65000+ characters.
You must be using a Text datatype field, which stores only 255
characters.
 
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?
Click to expand...

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]
 
John said:
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.
Click to expand...

That's a bit of a contradiction i.e. the limit is imposed by the thing
being typed into, which surely is the form or somthing on it!
What *can* cause it to be truncated is <snipped>
Click to expand...

Cast you mind back to our thread that discussing these issues( or
search the google groups usenet archive for the exact phrase "Suspected
causes of truncation of Memo"). The conclusions were that GROUP BY and
UNION (but not UNION ALL) were the only causes of truncation in a
query. ORDER BY and aggregate functions were dismissed as fallacies. If
you have any contrary findings, please post them.

Jamie.

--
 
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
 
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.
Click to expand...

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

John W. Vinson[MVP]
 
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.
 
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.
Click to expand...

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]
 
So even if I specify a ">" symbol for the format in the table?
Click to expand...

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]
 
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.
 
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!
 
Thank you. This solved my problem too. Thanks.

MSACSNewb said:
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!
Click to expand...
 
Back
Top