Dot Leader

[W. Guy Delaney]

I have an laddress directory and would like to have a dot leader extend from
the end of the name to the beginning of the telephone number.

Example

Jame and Marie Jones........................................(867) 232-7643

How can I get a dot leader to do that since the length of the dot leader
varies from name to name?

 

[fredg]

I have an laddress directory and would like to have a dot leader extend from
the end of the name to the beginning of the telephone number.

Example

Jame and Marie Jones........................................(867) 232-7643

How can I get a dot leader to do that since the length of the dot leader
varies from name to name?

See:
http://www.lebans.com/leaderdots.htm

 

[Tony Toews [MVP]]

http://www.lebans.com/leaderdots.htm

Cool. I never knew he had that functionality on his site.

Tony

 

[Tony Toews [MVP]]

I have an laddress directory and would like to have a dot leader extend from
the end of the name to the beginning of the telephone number.

Another alternative is alternate light grey and white lines

Dim fGray As Boolean

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Call AlternateGray

End Sub

Private Sub AlternateGray()
Const adhcColorWhite = &HFFFFFF

Me.Section(0).BackColor = IIf(fGray, 14408667, adhcColorWhite)
' Next time, do it the opposite of the way you did it this time.
fGray = Not fGray

End Sub