Cangrow property set but not working

  • Thread starter Thread starter Frank Reichenbacher
  • Start date Start date
F

Frank Reichenbacher

I set up a 10 record database with one text field and a simple form to go
with it. I stuck ~80-100 characters of text in the fields and then set the
CanGrow property of the textbox (very much smaller than is needed to display
all the data in the field) to Yes. No matter what the size of the textbox
and the data in the field, or the other properties that I set, I cannot get
the textbox to change size at all. There are no other controls or any other
features on the form.

This would be a useful feature in a for-real database that I am developing
and I want to implement it.

What am I missing? I have used CanGrow/CanShrink successfully many times on
reports but it doesn't seem to have any effect in a form.
 
Frank said:
I set up a 10 record database with one text field and a simple form to go
with it. I stuck ~80-100 characters of text in the fields and then set the
CanGrow property of the textbox (very much smaller than is needed to display
all the data in the field) to Yes. No matter what the size of the textbox
and the data in the field, or the other properties that I set, I cannot get
the textbox to change size at all. There are no other controls or any other
features on the form.

This would be a useful feature in a for-real database that I am developing
and I want to implement it.

What am I missing? I have used CanGrow/CanShrink successfully many times on
reports but it doesn't seem to have any effect in a form.
Click to expand...
Frank,
Read Access Help.
For a Form, the CanGrow property will only work when the form is
actually printed.

1) In the form, set the control height and width to display as much as
you can. Set the control's scroll bars property to Vertical.
The user will have to scroll.

Or .....

2) Code the control's Double-click event to:
DoCmd.RunCommand acCmdZoomBox

The user can double-click the control and the Zoom box will display the
text.
 
Back
Top