memofield doesn't grow

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

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
 
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.
 
Linq said:
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
Click to expand...
Perfect idea... I wrote the code like you suggested and..... it works!!!
Tanks
JP
 
Back
Top