Print Memo Field (2K and XP)

Topic

New Reply

Edited by HansV to provide links to posts – see Help 19

Greetings: I have a report that is printing a memo field. However, only 255 characters of the field print. How can I get the entire field to print? I posted this earlier (post 551895) and received a reply from Wendell (post 551899) stating that trying to format the field or sort on the field would cause this. However, this is not the case this time. Just trying to print. Thanks in advance.

Reply | Quote

Replies

Does this happen only when printing the report to paper, or also in print preview?

Reply | Quote

Both in Preview and Hard Copy

Reply | Quote

I would still suspect some kind of formatting or sorting on the memo field, either in the report itself or in its record source.

Could you post a stripped down copy of your database? See post 401925 for instructions.

Reply | Quote

Database attached. The report is selected using the form. CDBG is the selection in the dropdown. memProgramNotes is the field in question. Thanks again

Reply | Quote

I see that you have just posted the db, and the query does indeed use “distinct”.

My workaround was to remove the memo field from the query, and use a dlookup as the control source for the control on the report.

Are you clear about whether you need to keep the Distinct. I have not studied the logic of it enough to work this out myself.

Reply | Quote

I’m not entirely sure how DISTINCT shows up in queries. I know that I don’t explicitly put it in. I’m curious as to how a dlookup would work on this, if you don’t mind.

Reply | Quote

Normally, the DISTINCT keyword is set by setting the Unique Values property of the query to Yes.
In your query, Unique Values can be set to No without making a difference with respect to the returned records, since there is only a single record for a given program and year in tblAccomplishments, tblProgramExpenditures and tblProgramsNotes. If there would have been multiple records for a program and year in one of those tables, the situation could have been different.

Using DLookup, the control source of the notes text box could have looked like this:

=DLookUp(“memProgramNotes”,”tblProgramsNotes”,”intProgramID=” & [intProgramID] & ” AND intYear=” & Forms!frmProjectYear!intProjectYear)

To make this work, you must add the intProgramID field from tblPrograms to qryActivitiesFundingObjectives.

Reply | Quote

Thanks Hans, If the removing of DISTINCT causes additional problems, I’ll give this a go.

Reply | Quote

Some time ago I encountered a similar problem and discovered that if the query behind the report uses ‘distinct’ (or has the UniqueValues query property set to Yes ) the memo fields are truncated at 255 characters.

Here is Knowedge Base article

Reply | Quote

Hey John, Thanks for the reply. That was the case in this problem. DISTINCT was removed and the query and report seem to be functionally properly. Thanks again. Thanks for the referenced article also.

Reply | Quote