table of contents format

[Guest]

Is there a way to format a table of contents report with the ". . . . . . . .
.." leading out to the page number?

Like this:
Cats . . . . . . . . . . . . . . . . . . . . . . 1
Dogs . . . . . . . . . . . . . . . . . . . . . . 3
other critters that do not
deserve a section of their own . . . . 7

In MS Word, it is easy to do with a tab leader. Can this be done in MS
Access? How?

Thanks,
Rae Lynn

 

[Douglas J. Steele]

Assuming that there can be at most 50 periods, you could use something like

=Left([MyField] & String(".", 50), 50)

as the control source for the text box, rather than simply MyField.

 

[Guest]

Assuming that there can be at most 50 periods, you could use something like

=Left([MyField] & String(".", 50), 50)

as the control source for the text box, rather than simply MyField.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Is there a way to format a table of contents report with the ". . . . . .
. .
." leading out to the page number?

Like this:
Cats . . . . . . . . . . . . . . . . . . . . . . 1
Dogs . . . . . . . . . . . . . . . . . . . . . . 3
other critters that do not
deserve a section of their own . . . . 7

In MS Word, it is easy to do with a tab leader. Can this be done in MS
Access? How?

Thanks,
Rae Lynn

I couldn't get this to work: =Left([MyField] & String(".", 50), 50). It kept returning #Error. I'm using a 2 column page for my TOC.