Dot leaders in froms - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Dot leaders in froms

Tzvi Possick

4 years ago

How would I go about adding dot leaders in a form between 2 fileds? Such as

green peppers......$3.99lb
yellow peppers.....$2.99lb
Onions.............$1.99lb

	Kevin Robertson @Reply 4 years ago
Use the Len function to get the length of the first field, then use the String function for the dots. See screenshot below.

	Kevin Robertson @Reply 4 years ago

	Tzvi Possick OP @Reply 4 years ago
Wonderful. That works, but I see that I want it to be flush right on the right side. Is that possible?

	Juan C Rivera @Reply 4 years ago
add the dots to your label and if youe field can shrink or grow just have the dots all the way past the lable. make sure your field is not set to transparent.

	Kevin Yip @Reply 4 years ago
Try setting text align to "Distribute" (see pic below), which aligns the text to both the left and right sides. In the old days this was called "full justification."

	Kevin Yip @Reply 4 years ago

	Kevin Yip @Reply 4 years ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View