Placing fields in precise length when exporting? 1

[ffleitas]

Hello programmers,

When I export a report to an ASCII text file, I need to place them in an exact size and order. For example,
Client Number, Client Customer #, Client Name
Size 4 , Size 8, , Size 15

1234SC2345XXAcmeXMotorXXXXX

Please note that X's are spaces.

How can I do this with the parameters in the report?

Thanks,
Felix

 

[KenReay]

Hi

One way would be to use DoCmd.TransferText, to export the underlying query (of the report) results as a text file. Using the Import/Export Specification you can determine if the style of the exported file is to be fixed witdth (as you want) or csv etc Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK