ZipCodeField
(1)
StateField
(1)
CityField
(1)
TextBox
(1)
City
(1)

variable field width

Asked By John D.
21-Nov-09 04:29 AM
I need to display client name and associated address information. There are
three rows of data which are taken from the contacts table.

The field boxes are all fixed in width, I want to make the width dependant
on the data length, and if the field data are short, the boxes would leave no
extra white space.

I may have several field boxes in a row, and I would like the boxes to go
right next to one another without spaces, so each field box position is
anchored to the end of the previous field box.

How would I implement this?

John.

John D.

Rick Brandt replied to John D.
21-Nov-09 07:51 AM
If this is only for *display* then just use an expression in each of three
stacked TextBoxes that span the length you need for all the data on a row.
The TextBox will not change width, but the data will always be right next to
each other.

Example expression for City, State and Zip...

=[CityField] & ", " & [StateField] & " " & [ZipCodeField]
Post Question To EggHeadCafe