Using Can Grow in datasheet

[Barry A&P]

Is it possible to have a subform datasheet change row heighths depending on
how much text is in a control, i can get reports to do this but not datasheet
forms even though can grow is set to yes...

any ideas

Thanks
Barry

 

[Peter Hibbs]

Barry,

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples including one that does what you want.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[Tom van Stiphout]

On Wed, 24 Jun 2009 23:14:01 -0700, Barry A&P

The standard subform control in datasheet view cannot do that. Some
third party grid control may be needed, plus likely some VBA
programming.
CanGrow only pertains to printing. So if you wanted to print the form
directly, CanGrow would help print all text.

-Tom.
Microsoft Access MVP