Combine and Count

[vbaInet]

Are you using the query as the Record Source of a form? If not, do that instead. Cut the Concat code from the query and paste it into the Control Source of a textbox in this form.

 

[michibahn]

Are you using the query as the Record Source of a form? If not, do that instead. Cut the Concat code from the query and paste it into the Control Source of a textbox in this form.

actually the CONC query we made will just be exported to and excel file. I will not use any form..

 

[vbaInet]

Is the character limit on the query or when you export it?

 

[michibahn]

Is the character limit on the query or when you export it?

in the query output, it shows the complete contents of the field (261 characters) but when I export it to excel, the contents was stripped down to 255

 

[vbaInet]

I can only think of three ways:

* Create a table based on that query and remember to set the datatype to Memo. Export this to Excel
Or
* Create function to export parts of that field in chunks
Or
* Export to Word instead of Excel