How can I shrink fields horizontally?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to put the following information on the top of a report:

[First Name] [Last Name]
[Address]
[City], [State] [Zip]

I would like the fields to shrink to the size needed, not be fixed to the
size of the text box. Right now, for example, there is a huge space between
city and state when there is a short city.
 
Use concatenation.
For example, for the CitySTZip line place an unbound text control with a
Control Source of...
=[City] & ", " & [State] & " " & [Zip]
hth
Al Camp
 
Thanks - that worked! I can't tell you how long I searched for an answer to
that question.

AlCamp said:
Use concatenation.
For example, for the CitySTZip line place an unbound text control with a
Control Source of...
=[City] & ", " & [State] & " " & [Zip]
hth
Al Camp

LinguaKids said:
I am trying to put the following information on the top of a report:

[First Name] [Last Name]
[Address]
[City], [State] [Zip]

I would like the fields to shrink to the size needed, not be fixed to the
size of the text box. Right now, for example, there is a huge space
between
city and state when there is a short city.
Click to expand...
Click to expand...
 
Good deal.
You're welcome.. Al Camp

LinguaKids said:
Thanks - that worked! I can't tell you how long I searched for an answer
to
that question.

AlCamp said:
Use concatenation.
For example, for the CitySTZip line place an unbound text control with
a
Control Source of...
=[City] & ", " & [State] & " " & [Zip]
hth
Al Camp

LinguaKids said:
I am trying to put the following information on the top of a report:

[First Name] [Last Name]
[Address]
[City], [State] [Zip]

I would like the fields to shrink to the size needed, not be fixed to
the
size of the text box. Right now, for example, there is a huge space
between
city and state when there is a short city.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top