Form like report

  • Thread starter Thread starter Leif
  • Start date Start date
L

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
 
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...
 
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.
 
Back
Top