View Full Version : Link variable length report fields with a line


jj18
03-04-2001, 08:19 AM
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

Mike Gurman
03-04-2001, 12:38 PM
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