Link variable length report fields with a line

[jj18]

I want to link two text boxes in a report using a variable length dotted line to show that the data on the right relates to the data on the left e.g.

Items supplied by John..............Page 2
Details of orders...................Page 3

 

[Atomic Shrimp]

This method is crude, but ought to work:

Widen the first text box so that it fits right up to the edge of the second one and change the control source from
[YourControlSourceObject]
to
=[YourControlSourceObject] & ".................."

Just be sure to use enough dots to still reach the end of the box even with the shortest value.

HTH

Mike