Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

remove line break when exporting to txt file

Copper Contributor

I am working with access 2016, I have created a report with a single line and 4100 characters/columns.
The file in the report is correct, if I copy the report data and paste it in a txt, the program where it is directed recognizes it well.
Now if I tell the report to convert it directly to txt, it creates the file but it makes line breaks and backspace of expensive. and I do not know how I can do so that when exporting it, it respects the width and characters.

I would appreciate your help,

4 Replies
Presumably the report is based on a table, and that table has a Long Text field with 4100 characters. Is that correct?
If so, you can use DoCmd.TransferText to export directly from the table. No report needed or wanted.

@Juan_Palma, you can't expect that all "text formatting" will be exported to a "plain" text file.

import it as an html or a richtext.

thank you for your reply

could you tell me how to write the code of a table called table1 and the field where it is stored is called document.
I would appreciate it very much
hank you for your reply

could you tell me how to write the code of a table called table1 and the field where it is stored is called document.
I would appreciate it very much