If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access memo field problem/question
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? |
#2
|
|||
|
|||
Access memo field problem/question
On Tue, 4 Aug 2009 14:05:01 -0700, bunman
wrote: 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. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Access memo field problem/question
"John W. Vinson" wrote: On Tue, 4 Aug 2009 14:05:01 -0700, bunman wrote: 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. -- John W. Vinson [MVP] 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? |
#4
|
|||
|
|||
Access memo field problem/question
On Tue, 4 Aug 2009 14:44:01 -0700, bunman
wrote: 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/micro...public.access# Several (very odd) options there, one of which might be the problem here. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|