.txt output from report

[dhopper]

Hello all, I'm new to the forum and have a question on a .txt file I'm trying to generate. I have developed a database for tracking transactions. Basically, I take all of the transactions at the end of the day and sum them to see if any meet a preexisting threshold. If they do they need to go on a report that will be exported to a .txt file. Now for my issue...



I have everything layed out in the report, many many concats which result in very long strings. My issue is, this thing cuts off when i export to .txt. Is there a way around this? Also, if not would it be possible to write some vba to make it export properly? Thanks for any help in advance.

[NTC]

First let me say - I'm not sure - but is that cut off at the 255 character point?

If so - - just as a sanity check - make a Memo field type in a table - populate a record with more than 255 characters - - and see if the whole thing exports....

If this does work - - then it points to a solution in that you might need to write the data, once all concatenated to a new table that has a memo field - - and then do your report of that and export....

but this is a swag at this point.....