Shrink Horizontally

[Kay]

I have a report that has field values selected by a form. I would like for
the text boxes on the report to shrink/grow horizontally on the report. I do
not want to use anything like ([field1] & " " & [field2] & " " & [field3])
It would make the report uneven as not all records hold the same text length.
Prefer code over macro.

Thank you in advance.

Kay

 

[Marshall Barton]

I have a report that has field values selected by a form. I would like for
the text boxes on the report to shrink/grow horizontally on the report. I do
not want to use anything like ([field1] & " " & [field2] & " " & [field3])
It would make the report uneven as not all records hold the same text length.
Prefer code over macro.

Why do you care? What effect are you trying to get?

If all the contents of each text box fit on one line, then
you can use the TextWidth method. For multi line text
boxes, you can use the TextHeightWidth function at
www.lebans,com

If they can grow both horizontally and vertically, then you
must have some way to determine how much in each direction.

 

[Kay]

Thanks

I have a report that has field values selected by a form. I would like for
the text boxes on the report to shrink/grow horizontally on the report. I do
not want to use anything like ([field1] & " " & [field2] & " " & [field3])
It would make the report uneven as not all records hold the same text length.
Prefer code over macro.

Why do you care? What effect are you trying to get?

If all the contents of each text box fit on one line, then
you can use the TextWidth method. For multi line text
boxes, you can use the TextHeightWidth function at
www.lebans,com

If they can grow both horizontally and vertically, then you
must have some way to determine how much in each direction.