Reports and Autosizing Textboxes

Greetings,

In Access 2003, I have on a report where I have 3 texts boxes side by side.
They are City, State, and Zip Code. I don’t know enough about code to
develop it on my own, so I was wondering how I could get the fields to auto
size based on length of the field before it.

e.j. New York NY 23156
or Albuquerque NM 87106
or Tallahassee FL 12358
or Salem OR 78956

I can’t have it overlap where…
e.j. New Y NY 23156
or Albuqu NM 87106
or Tallaha FL 12358

Neither can I have a space between the two such that…
e.j. NewYork NY 23156
or Albuquerque NM 87106
or Tallahassee FL 12358

How can I go about having all 3 fields resize based on the length of the text
in the text boxes?

Why not combine the three fields into one and only have a single textbox?

You can do this as a calculated field in the query used as the report's
RecordSource, or you can simply set the ControlSource of the single text box
to =[City] & " " & [State] & " " & [Zip Code] (include the equal sign)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"eMJeF" u53685@uwe wrote in message news:99daa7321392d@uwe...
Greetings,

In Access 2003, I have on a report where I have 3 texts boxes side by
side.
They are City, State, and Zip Code. I don't know enough about code to
develop it on my own, so I was wondering how I could get the fields to
auto
size based on length of the field before it.

e.j. New York NY 23156
or Albuquerque NM 87106
or Tallahassee FL 12358
or Salem OR 78956

I can't have it overlap where.
e.j. New Y NY 23156
or Albuqu NM 87106
or Tallaha FL 12358

Neither can I have a space between the two such that.
e.j. NewYork NY 23156
or Albuquerque NM 87106
or Tallahassee FL 12358

How can I go about having all 3 fields resize based on the length of the
text
in the text boxes?

That is Genuis! Thank you very much! It worked.

Douglas J. Steele wrote:
Why not combine the three fields into one and only have a single textbox?

You can do this as a calculated field in the query used as the report's
RecordSource, or you can simply set the ControlSource of the single text box
to =[City] & " " & [State] & " " & [Zip Code] (include the equal sign)

Greetings,

[quoted text clipped - 23 lines]
text
in the text boxes?