Dot Leader

W

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?
 
F

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
 
T

Tony Toews [MVP]

W. Guy Delaney said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top