Exporting data into a mail merge doc with spaces?

[bluedollar]

I am storing data to be used in a report, however I need to store some of these fields at a guarenteed specified length.

For example I have a field called SER_NO, this needs to be stored at a length of 20 characters. For example if the user inputs 5 characters, then the data needs to be stored as:

nnnnnsssssssssssssss

n = data character
s = space

The reason for this is that the data is mail merged to word, and in the final report, the users want the data to look as follows:

nnnnn
____________________

(NB. data underlined and then the underline continued upto 20 characters)

What would be perfect would be to store the data as it is, and then when I mail merge (I mail merge off a query), then the query correctly formats the data to export into the mail merge.

Or there may be a better way of achieving the above.

Any ideas would be greatly appreciated.

Thanks

Dan

 

[dawnd3]

I think it would be easier to create the space and the line the lenghth that you want it in word. You can use tab settings for spaces and the drawing toolbar to draw the line the length that you want.

Hope this helps,

Dawn

http://www.calliopeconsulting.net