Resize textbox in a datasheet

[Ananya Sagar]

I have a subform in which I am using a datasheet to display & edit results
from a table.In one of the columns in the datasheet, a user writes his or her
comments.I want the textbox/column to expand as user is typing to accomodate
all the text iin one textbox which is visible to everyone.My question is it
possible to increase the size of a data sheet cell dynamically/run time.
I know it is possible to do it for atextbox but is it possible to do it for
a datasheet cell?

 

[Tom van Stiphout]

On Tue, 10 Nov 2009 20:22:06 -0800, Ananya Sagar

No. Especially the concept of having each row be of variable height to
accommodate a Notes field is not possible with datasheet, nor with any
other Access solution. This would require a suitable 3rd party grid
control.

Users can hit Shift+F2 on any field to get a zoom box.

-Tom.
Microsoft Access MVP

 

[Ananya Sagar]

Thank You for Replying ..
I dont want each row to be of variable height .if all rows simaltaneously
increase in height as one row increase in height , it would be fine ... Is
that possible ??

 

[Tom van Stiphout]

On Wed, 11 Nov 2009 07:09:01 -0800, Ananya Sagar

Not for datasheets, but Continuous Forms can be set to a certain
height of more than one row of text.

-Tom.
Microsoft Access MVP

 

[David W. Fenton]

Not for datasheets, but Continuous Forms can be set to a certain
height of more than one row of text.

Again, Tom, you're vastly underselling the capabilities of
datasheets.

The .RowHeight property is available for setting this. It is -1 by
default, which means standard height. Any other setting is in twips
(1440 to the inch).

My suggestion would be to manually alter the height of the row to
look correct and then test its RowHeight, and then put that in your
code.