Access memo field problem/question

[bunman]

I have a couple subforms within a main form. All have a couple memo fields
that will not give me more than 255 characters. I've looked at everything, so
I think. Has anyone run into this problem that can help resolve?

 

[John W. Vinson]

I have a couple subforms within a main form. All have a couple memo fields
that will not give me more than 255 characters. I've looked at everything, so
I think. Has anyone run into this problem that can help resolve?

There are several reasons why a Memo field may be truncated: using a Format
(either in table properties, query properties, or as a format on a textbox on
a form); sorting or grouping by the field; including the field in a UNION
query...

Perhaps you could post the SQL view of the query upon which the subform is
based.

 

[bunman]

There are several reasons why a Memo field may be truncated: using a Format
(either in table properties, query properties, or as a format on a textbox on
a form); sorting or grouping by the field; including the field in a UNION
query...

Perhaps you could post the SQL view of the query upon which the subform is
based.

Thanks John, but I don't believe any of those are the answer. Could it be
perhaps it's because my subforms are based on tables and not queries? Also,
I'm running Access 07 on Windows EX Pro SP3?

 

[John W. Vinson]

Thanks John, but I don't believe any of those are the answer. Could it be
perhaps it's because my subforms are based on tables and not queries? Also,
I'm running Access 07 on Windows EX Pro SP3?

I've seen some posts indicating that A07 has bugs in this regard - there may
be a hotfix. Checking...

See the thread from "John" at
http://groups.google.com/group/micr...emo+truncation+group:microsoft.public.access#

Several (very odd) options there, one of which might be the problem here.