Resize textbox in a datasheet
Ananya Sagar
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?
--
Thanx for helping
Tom van Stiphout
<Anany...@discussions.microsoft.com> wrote:
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
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 ??
--
Thanx for helping
"Tom van Stiphout" wrote:
> .
>
Tom van Stiphout
<Anany...@discussions.microsoft.com> wrote:
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
news:thrmf5h2uktdel11h...@4ax.com:
> 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.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/