Issue with subform field (datasheet view) not growing

[SElgin]

I have a main form with a subform to display comments about that client.
The subform is in datasheet view so that it shows all the comments.
There is only one field on the subform visible and that is the comment field
(memo data type).
I would like to have the field grow if there is more info than will display
in the box. I have the can grow property set to yes. Is there someplace
else I need to look in order for this to happen?

I posted this on the MS Access forum and now when i try to look at the Forms
posts, I get a message that the service is unavailable, so I am reposting
here.

TIA for the help.

Steve

 

[bcap]

The CanGrow property only applies when the form is printed, it has no effect
in datasheet view.

You could programmatically control the height of the rows using the
RowHeight property, but you might have a bit of a nightmare figuring out how
many lines of text are actually being displayed and hence how high the rows
need to be in the relevant font. Also, setting the RowHeight affects all
the rows.

Other than that, I think you are outta luck: there is simply no way to make
a datasheet behave like a report i.e. with rows of differing heights
depending on the data.