How can I shrink fields horizontally?

[LinguaKids]

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.

 

[AlCamp]

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]

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

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

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.

 

[AlCamp]

Good deal.
You're welcome.. Al Camp

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

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

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.