Adding " . . . . "s to a report 1

[rcoutts]

I'm creating an Invoice Report that I want to look something like this:

  BALANCE
    Previous Balance    .    .    .    . $1000
    Amount Received     .    .    .    .    50
    Interest  .    .    .    .    .    .     3

  FEES
    Hourly Fee     .    .    .    .    .  2000

  CONSULTANTS
    Structural consultant for framing  .   500

  TOTAL AMOUNT DUE UPON RECEIPT.    .    $3453

Because some of the lines vary in length (e.g., "Structural consultant for framing&quot what's the best way to insert the dots? In addition to the number of dots changing for each line, they have to align vertically and they obviously can be seen through the text.

Thanks!
Rich

 

[CosmoKramer]

Try this:
Set up an invisible text box whose control source is a string of periods and spaces, i.e. txtDots

=". . . . . . . . . . . . . . . . . . . . ."

For the actual print lines in your report, set up something like this in the control source:

=[txtPrevBalance] & Right([txtDots],(40-Len([txtPrevBalance])))

In this case, 40 is the total length of the txtDots text box. This new field will then be:

Previous Balance . . . . . . . . . . . .

Hope this helps....