By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,044 Members | 1,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,044 IT Pros & Developers. It's quick & easy.

Blank Spaces In Export Text File

P: 11
Hi everyone,

My problem is whenever I export a report to a textfile. The output textfile have blank spaces.

Here is my query:

SELECT ([Name] & '|' & [Company) & '|' & [Address] & '|' & [Employee_ID] ......................and so on .........................AS EXPR1
FROM [Table1];

My report is like this

1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1| 1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|
1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1| 1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|11|1|1 |1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1 |1|1|1|11|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1| 1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1| 1|1|1|1|1|1|1|1|1|1|1|1|1|

1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1| 1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1| 1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1| 1|1|1|1|11|1|1|1|1|1|1|1|1|1|1|1|1|1|1|11|1|1|1|1| 1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1| 1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|11|1|1|1|1|1|1|1 |1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1 |1|1|1|1|1|1|1|

Ive read that we can adjust the sections detail to 0.125 in order to eliminate the blank spaces. That works if the fields are not as long as mine.


My concatenated fields are 200 fields. And That is too long for a report. I have 4 BLANK SPACES because I have 4 PAGES of Report(Landscape). It cuts the data per page.

I would like the data to be printed in the textfile continously... as if Its only One page. This should be done in a report because I have also fields in in header and also tables in details.

I would like to know how to eliminate blank spaces in a textfile report.

I am using MS Access 2003.

Thank you so much!
Sep 24 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,761
I suspect this will be as simple as saying "Don't export the report,"

Export the table instead. It's easier and more logical.
Sep 24 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.