City state zip question

rbuser

If I had 3 fields in a database for each of these fields and I wanted to
print them on a report and have them move horizontally on the page based on
how long the field to its left is. Can this be done with report builder? I
know how to shift relative to vertically but not sure how to handle fields
that need to move horizontally.

Thanks,

glenn

rbuser

Glenn,

Not certain what conditions will cause the field to "move", but if it is a
change in the form size, the anchor function will do this.

If you are wanting to keep the city from overwriting the state and zip, use
a variable and concatenate the fields together.

--

Bob

rbuser

I can do that but to answer your question, the size of the field to its left
would be what caused it to shift. ie: I have a field 1" long to the left
of field2. If that field became 2" long then the field set to shift with it
would move relative to the fields new length. ie: It would work exactly
like shift relative to now except in the horizontal instead of the
vertical...

But I guess it can't be done so I'll just create a var to hold my data...

Thanks,

glenn