Output to a text file

[neemi]

I need to output certain fields to a text file using access 2002.

The fields that I need to output need to be on this text file at certain points. i.e. Ref number on the first line with the end character position of the field at character position 16.

The user name need to end at character position 42. Therefore if the username is 5 digits long it will begin at character position 37. If it is 10 digits long it will begin at character position 32. The important part is the character position's that the fields end at.

If I have not explianed very well let me know.

Can anyone advice.

I know I can use the Print command but I don't know how I can make sure I get the end character positions of the fields to be correct.

Cheers in advance.

Neemi

 

[vb6novice]

Neemi,

The thing to do is to create a string for each record that you want to output that has the text properly placed. For example, if Ref number is 6 digits long, then it needs to have 10 spaces placed in front of it.

For a = Len([Ref number]) To 15
    stringout = stringout & Chr(32)
Next a
stringout = stringout & refnum

This will place the last character of Ref number at position 16. Do likewise for any other that you need. Then just write the string to the text file.