phone book report

[seanmflynn]

I have to produce a phone book report. There are three columns: parents
names, childrens names and phone number. Both the parents and childrens
names have the "can grow" property turn on as they may exceed the space
on a single line. This works great but what I want now is the ability
to include a series of dots (e.g. periods) in the white space between
the fields. This allows someone reading the phone book to easily scan
across the page from the names to the phone number.

Is there a way to shrink fields horizontally based on the length of the
text in them? If I could do that then I could simply put a label field
behind the columns that would show up automatically when they shrink
horizontally.
TIA, Sean

 

[Rick B]

One way is to change them to unbound text boxes and put the following...

=[LastName] & ", " & [FirstName] & "...................................."

If the field is a set width, it should work for you.

I have seen another post out here that pointed to a more programatic way to
do it. It was an example on one of the MVP webpages. You might do a search
and see if you can find the previous post. I'd search for "dot leader".

 

[Jeff Conrad]

See MVP Stephan Lebans for all things magical:

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

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

One way is to change them to unbound text boxes and put the following...

=[LastName] & ", " & [FirstName] & "...................................."

If the field is a set width, it should work for you.

I have seen another post out here that pointed to a more programatic way to
do it. It was an example on one of the MVP webpages. You might do a search
and see if you can find the previous post. I'd search for "dot leader".

--
Rick B

I have to produce a phone book report. There are three columns: parents
names, childrens names and phone number. Both the parents and childrens
names have the "can grow" property turn on as they may exceed the space
on a single line. This works great but what I want now is the ability
to include a series of dots (e.g. periods) in the white space between
the fields. This allows someone reading the phone book to easily scan
across the page from the names to the phone number.

Is there a way to shrink fields horizontally based on the length of the
text in them? If I could do that then I could simply put a label field
behind the columns that would show up automatically when they shrink
horizontally.
TIA, Sean

 

[seanmflynn]

I had tried this approach but with the "can grow" property turned on it
simply expands the field vertically to accomodate the dots at the end.
I did find another post where someone is dynamically resizing fields
based on the text length but it seems like quite bit of code. I was
hoping for a simplier approach.

Thanks,
Sean

 

[Rick B]

That's the one!!!


--
Rick B

See MVP Stephan Lebans for all things magical:

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

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

One way is to change them to unbound text boxes and put the following...

=[LastName] & ", " & [FirstName] & "...................................."

If the field is a set width, it should work for you.

I have seen another post out here that pointed to a more programatic way to
do it. It was an example on one of the MVP webpages. You might do a search
and see if you can find the previous post. I'd search for "dot leader".

--
Rick B

I have to produce a phone book report. There are three columns: parents
names, childrens names and phone number. Both the parents and childrens
names have the "can grow" property turn on as they may exceed the space
on a single line. This works great but what I want now is the ability
to include a series of dots (e.g. periods) in the white space between
the fields. This allows someone reading the phone book to easily scan
across the page from the names to the phone number.

Is there a way to shrink fields horizontally based on the length of the
text in them? If I could do that then I could simply put a label field
behind the columns that would show up automatically when they shrink
horizontally.
TIA, Sean