Re: Auto-expand continuous subform memo fields

And since Stephen didn't mention it, I'll just mention that the limitation
isn't Stephen's: it's caused by how Access draws forms. There's only one
instance of each control, repeated multiple times, so if you change a
control, those changes are replicated to each row.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@xxxxxxxxxxxx>
wrote in message news:%23E%236NeRHGHA.3700@xxxxxxxxxxxxxxxxxxxxxxx
> No.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Jerry K" <JerryK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:8E8919C2-55D4-427F-9C54-CBED4308F863@xxxxxxxxxxxxxxxx
> >I want a subform (listing several records) to auto-expand each row to the
> > height required to show all the text in a memo field in that row. I've
> > looked
> > at Stephen Lebans AutoSizeTextBox and TextHeightWidth, but both seem to
> > re-set the height of all the rows displayed to that of the current
record.
> > Is
> > there a way to apply the re-sizing to each record?
>
>


.

Relevant Pages

  • Re: PrintLines without border in last record
    ... Dim CtlDetail As Control ... For Each CtlDetail In Me.Section.Controls ... Stephen Lebans escreveu: ... Please respond only to the newsgroups so everyone can benefit. ...
    (comp.databases.ms-access)
  • Re: Conditional formatting changes field enabled property?
    ... "Stephen Lebans" wrote: ... set the FomatConditions object props for this control to the previously ... Access Code, Tips and Tricks ... with programming ability like you would have already done it. ...
    (microsoft.public.access.forms)
  • Re: PrintLines without border in last record
    ... Add a logic check before the current code is called to draw any lines. ... I sent in your email the example with problem in report. ... Stephen Lebans escreveu: ... Dim CtlDetail As Control ...
    (comp.databases.ms-access)
  • Re: Conditional formatting changes field enabled property?
    ... it will HOLD that user-set formatting forever (until the user ... "Stephen Lebans" wrote: ... return True or Flase depending if you want CF to paint the control or not. ... Access Code, Tips and Tricks ...
    (microsoft.public.access.forms)
  • Re: PrintLines without border in last record
    ... Stephen Lebans escreveu: ... I sent in your email the example with problem in report. ... Alternatively, if I remember correctly, the PrintLines class solution on ... Dim CtlDetail As Control ...
    (comp.databases.ms-access)