memofield doesn't grow

[Jean-Paul]

Hi,
I have a "continuois form" with 2 fileds:
date and memo field

I have set the memeofield so it can grow or shrink
I set the initial hight to 0,5 but when displaying the memofield doesn't
grow if it contains more characters then can be displayed in the initial
field-boundaries

Who can help?

Thanks
JP

 

[Graham Mandeno]

Hi Jean-Paul

The CanGrow and CanShrink properties only affect a control when it is
printed. It has no effect on the size as displayed on a form on the screen.

 

[Evi]

Stephen Lebans has designed a CanGrow database where a textbox in a form can
grow
http://www.lebans.com/cangrow.htm
See if that helps

Evi

 

[Jean-Paul]

I believe you're going to find that Stephen's innovative hack is not going to
work in this situation, with a Continuous form. I believe you'll find that
the memo field will remain as originally sized in Design View And when you
stop and think about it, would you really want it to automatically expand in
a Continuous form? You normally navigate thru a Continuous form by scrolling,
and with large memo fields expanding to show all contents, this could be very
unwieldly. You might think about letting your users expand a given memo field
control by double-clicking on it, with something like this


Private Sub YourMemoField_DblClick(Cancel As Integer)
YourMemoField.SetFocus
DoCmd.RunCommand acCmdZoomBox
End Sub

Perfect idea... I wrote the code like you suggested and..... it works!!!
Tanks
JP