Access memo field problem/question

  • Thread starter Thread starter bunman
  • Start date Start date
B

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

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.
 
John W. Vinson said:
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.
Click to expand...
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?
 
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?
Click to expand...

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.
 
Back
Top