Stephen Lebans' CanGrow

[Question Boy]

I am trying to implement Stephen's CanGrow to resize a text box on a
continuous form based on the control's content. However , I keep getting an
error 2465? The detail section and the control are set to can grow and can
shrink to yes, and the text box has scroll bars set to none.

Anyone have any ideas?

QB

 

[Question Boy]

Forgot to mention it keeps highlighting the before 3rd to last line in the
function

ctl.Parent.Detail.Height = ctl.Top + ctl.Height

 

[Stephen Lebans]

There is absolutely no way to programmatically resize individual rows for an
Access form set to Continuous or Datasheet view. No native Access solution
exists.

The only possible solution is to use a Treeview ActiveX control. This would
entail a lot work, coding and headaches.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.