Stephen Lebans' CanGrow function (Access97)

[Wally]

Hi All,

I'm using Stephan Lebans' nifty code for automatically resizing text
fields to the size required to show (almost) all text in that field
(CanGrow3, thanks Stephen!).

In general this function works great. However, I sometimes have a
problem with the last text line. Often the last line is just below the
end of the field and to view that line I have to scroll to it. Is that
a known problem? And is there a solution?

I've been suggested to insert this in the lostFocus event:

& Chr(13) & Chr(10) &

It obviously takes a little more than that. The code has probably to
be preceded by something else, but what?

Thanks,

Wally

[Stephen Lebans]

Wally, at the top of the Web page for CanGrow is the following
statement:

Use the updated fTextWidth and fTextHeight functions for an accurate
solution.
http://www.lebans.com/textwidth-height.htm is a replacement for the
Report object's TextWidth and TextHeight methods. It is multiline aware
and can work in both Report and Form views.

Did you follow these instructions to use the newer more accurate code?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Wally" <wr***********@chello.nl> wrote in message
news:d6**************************@posting.google.c om...

Hi All,

I'm using Stephan Lebans' nifty code for automatically resizing text
fields to the size required to show (almost) all text in that field
(CanGrow3, thanks Stephen!).

In general this function works great. However, I sometimes have a
problem with the last text line. Often the last line is just below the
end of the field and to view that line I have to scroll to it. Is that
a known problem? And is there a solution?

I've been suggested to insert this in the lostFocus event:

& Chr(13) & Chr(10) &

It obviously takes a little more than that. The code has probably to
be preceded by something else, but what?

Thanks,

Wally

[Wally]

Thank you Stephen.
No I hadn't seen the new version. I'm sure that I can get this to work
with my forms. Thanks also for posting the other very usefull pieces
of code on your pages.

Cheers,

Wally
to "Stephen Lebans" <St***********@mvps.org> wrote in message news:<yk********************@ursa-nb00s0.nbnet.nb.ca>...

Wally, at the top of the Web page for CanGrow is the following
statement:

Use the updated fTextWidth and fTextHeight functions for an accurate
solution.
http://www.lebans.com/textwidth-height.htm is a replacement for the
Report object's TextWidth and TextHeight methods. It is multiline aware
and can work in both Report and Form views.

Did you follow these instructions to use the newer more accurate code?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Wally" <wr***********@chello.nl> wrote in message
news:d6**************************@posting.google.c om...

Hi All,

I'm using Stephan Lebans' nifty code for automatically resizing text
fields to the size required to show (almost) all text in that field
(CanGrow3, thanks Stephen!).

In general this function works great. However, I sometimes have a
problem with the last text line. Often the last line is just below the
end of the field and to view that line I have to scroll to it. Is that
a known problem? And is there a solution?

I've been suggested to insert this in the lostFocus event:

& Chr(13) & Chr(10) &

It obviously takes a little more than that. The code has probably to
be preceded by something else, but what?

Thanks,

Wally