Controlling spacing in an exported .txt file.

[cwhite23]

Here's one for all you gurus out there! We do a lot of work with the Federal government and as a result, we have to do things their way. One of the things that they require is that for each order that comes in, we have to send a response back to them. The response is always in an 80 column line format. Does anyone have any ideas on how to control the output from VBA to a text file so that specific information will always end up at the right space on the line? For example, the Supplementary Address should always start at position 45 in the 80 column format. I've already gotten the data together and can concatenate it, but how do I control what goes where if the data lengths are variable? Any help would be greatly appreciated.

 

[smedvid]

I think u can use the SPACE or similar function under MS Access to imbed blanks within a string. You can derive the n value based on the Len() versus the fixed length of 80? htwh,



Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[payback]

Have a look at the formatting in the following string -

strLine = strLine & Format(rst!ToPayee, "!@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@")

It worked in Access 97 but I have not tried in the later versions. The code was written about 5 years ago for data to banks.

 

[payback]

I forgot to supply the reference. Search the Help in the VB window for "User-Defined String Formats (Format Function)" because there are others you can use also.

 

[Clipper2000]

You can try the FSO, look it up in the Object Browser.

 

[cwhite23]

actually, I ended up using the TAB command and it worked perfectly. Thanks everyone.

 

[smedvid]

Ok, I found my code. I created a field called Count, and then created a text box that used a SPACE() to pad the report form to force data to another page based on Count.

=IIf(Count([LoanNo])>20,Space(5000),Space(1))

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...