Adding Memo Fields on query bound reports

[jaaret]

I've been designing reports with a concatenated list of names. I'm using a concatenate function designed by Duane Hookom in the underlying query. The problem is the underlying query truncates the list of names after the 255th character.

I've developed one work around with by dropping a memo field into the report from a dummy table, then using SetValue and the concatenation function to list all the names in the memo field. Is there a way to drop in an unbound memo field, or do memo fields need to be available in a table to drop them into a report?

Jaaret

 

[dhookom]

The Concatenate() function will return more than 255 characters. I expect your issue is caused either by your sql or your report.

Can you see more than 255 characters in the data sheet of your record source query?

Can you provide the SQL view of your query?

Where in the report are you attempting to display the results of the concatenate function?

Duane MS Access MVP
Now help me support United Cerebral Palsy