Can Shrink/Can Grow in Forms

[Guest]

I've got a continuous form to display the details of a project. The comments
field may contain no data, or may contain several sentences.

Is there absolutely no way that I can get the comments text box control to
grow/shrink in my continuous form to display all data? More often than not,
the comments field will display nothing, so I don't want it to take up space,
but when it does contain data, I want the user to be able to easily view it.

Suggestions?

I guess my plan B would be to add a button by which the user could
expand/contract the text box (for all records, I suppose).

KellyB

 

[Rick Brandt]

I've got a continuous form to display the details of a project. The comments
field may contain no data, or may contain several sentences.

Is there absolutely no way that I can get the comments text box control to
grow/shrink in my continuous form to display all data? More often than not,
the comments field will display nothing, so I don't want it to take up space,
but when it does contain data, I want the user to be able to easily view it.

Suggestions?

I guess my plan B would be to add a button by which the user could
expand/contract the text box (for all records, I suppose).

You could invoke the built in zoombox on the double-click event.

DoCmd.RunCommand acCmdZoomBox

(going from memory there, but that's close)

 

[fredg]

I've got a continuous form to display the details of a project. The comments
field may contain no data, or may contain several sentences.

Is there absolutely no way that I can get the comments text box control to
grow/shrink in my continuous form to display all data? More often than not,
the comments field will display nothing, so I don't want it to take up space,
but when it does contain data, I want the user to be able to easily view it.

Suggestions?

I guess my plan B would be to add a button by which the user could
expand/contract the text box (for all records, I suppose).

KellyB

CanGrow and CanShrink for Form controls only work when the form is
printed.
Use a Zoom Box.
Code the control's Double-click event:

DoCmd.RunCommand acCmdZoomBox