View Full Version : Adding blank spaces at the end of lines and outputting to a text file


ant101
05-20-2008, 06:45 AM
Hi,
I need to add 15 blank spaces at the end of a string in my report and output this to text file. Access seems to leave the last spaces from the report and does not export it to a text file. Does anyone know how to add spaces at the end of a string and make access output these spaces?

An example of the query for my report is:

headerinfo: " Programme 1 RWED 4............... " (the dots are indicating where the spaces should be)

The spaces after the 4 are never saved to the text file (MS DOS format)
Even if I add a "blank" label to my report the spaces are not saved
Example :
"............. "
Any suggestion on how to get the spaces at the end of line to be in a text would be greatly appreciated.
I can't do without them!

Thanks