phone book report

S

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
 
R

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".
 
J

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
 
S

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
 
R

Rick B

That's the one!!!


--
Rick B



Jeff Conrad said:
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
 

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