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
|
|||
|
|||
memo field in the select query
I have a memo field in my select query and only return 255 characters.
Do I need specify any return type using select query for memo field? The query is for the report. The report does not show all the information in the memo field. Your help is great appreciated, |
#2
|
|||
|
|||
memo field in the select query
If the memo field is returning only 255 characters, you may have
-- sorted by the memo field -- returned distinct rows -- used a totals query and grouped on the memo field -- applied formatting to the field or to the control that is bound to the field. John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County inungh wrote: I have a memo field in my select query and only return 255 characters. Do I need specify any return type using select query for memo field? The query is for the report. The report does not show all the information in the memo field. Your help is great appreciated, |
#3
|
|||
|
|||
memo field in the select query
inungh wrote:
I have a memo field in my select query and only return 255 characters. Do I need specify any return type using select query for memo field? The query is for the report. The report does not show all the information in the memo field. Check your query for thibga kike Distinct, Group By, Order By, etc. that require the memo field values to be compared. Using the Format property of the memo field's text box on the report will also truncate a long string. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|