Form like report

[Leif]

I've developed some Access forms that are "form-like". In other words, I
have multiple text fields stacked vertically. I wish somehow these fields
could grow, but in forms they are not allowed to dynamically grow. So my
work-around is to allow the user to double-click the field to show the entire
content of the field without having to scroll through the field.

In reporting grow works fine. However, the kicker is that Access reports
will cut a field into two parts if it straddles a page boundary.

I've read suggestions of this forum that one way to is split each text field
into separate groups where the header, detail, and footer sections are used
to separate the growing text fields. However, with about 40 or 50 text
fields that may grow this seems very ackward. 50 would require 17 groups. I
don't know the limit on the number of groups, but I suppose that could also
become an issue.

Does anyone have an idea for a work-around?

Thanks,
Leif

 

[Klatuu]

Steve Lebans is the best there is with this sort of thing. Go to this site
and download the example database that demonstrates how to simulate Growing
on a form:

http://www.lebans.com/cangrow.htm

 

[Leif]

This is no fun...

Perhaps the MVPs can suggest this as an upgrade to Access. Perhaps a
do-not-break property for text related controls. It won't do me any good,
but perhaps it will help some person down the line...

 

[Leif]

Thanks for the 4K limitation information. I was not aware of that.

I my particular case, however, the text will be absent or very short. I was
wondering if something like what was done for forms, in Klatuu's post, could
be done in reports (lebans's Can Grow database form)? In otherwords,
analysize the size of the text field and if it looks like it will split to
the next page next force it onto a new page? Not easy, if it is possible,
but it is a more general solution, although it might not work across
subreports.