By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,318 Members | 2,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,318 IT Pros & Developers. It's quick & easy.

Stephen Lebans' CanGrow function (Access97)

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.