Access 2000 Report/Leader Dots (2000 SP2)

Topic

New Reply

I was wondering if I’m able to fill a field in with leader dots. For instance, name…… (333) 333.3333. Where name and phone number are 2 different fields and I want the name field to justify out with leader dots. Any creative solutions? Thanks much

Reply | Quote

Replies

Well, you could use the String() function. That allows you to produce a string of the same character of a given length:

=[name] & String(60-(Len([name])+Len([phonenumber])),”.”) & [phonenumber]

Just play with the number 60 until you get total field the length that you want it.

Reply | Quote

On further consideration, this will not work. I failed to consider the varying width of different characters. Just having the same number of characters will not make them line up properly.

You could make a text box composed entirely of dots then overlay this text box with your name and phone number boxes at each end.

Reply | Quote

You can get over the problem of “varying width of different characters” by using a font with fixed spacing.

Reply | Quote

When I found this on the vb world site I recalled your post!

I

Reply | Quote