(Msg. 1) Posted: Fri Sep 05, 2008 12:30 pm
Post subject: Shrink Horizontally Archived from groups: microsoft>public>access>reports (more info?)
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.
(Msg. 2) Posted: Fri Sep 05, 2008 4:54 pm
Post subject: Re: Shrink Horizontally [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Kay wrote:
>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.
(Msg. 3) Posted: Fri Sep 05, 2008 4:54 pm
Post subject: Re: Shrink Horizontally [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks
"Marshall Barton" wrote:
> Kay wrote:
>
> >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.
>
> --
> Marsh
> MVP [MS Access]
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other