Shrink Horizontally

  • Thread starter Thread starter Kay
  • Start date Start date
K

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
 
Kay said:
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.
Click to expand...


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.
 
Thanks

Marshall Barton said:
Kay said:
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.
Click to expand...


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.
Click to expand...
 
Back
Top