Number of lines in Memo?

[Guest]

Hello,

Anyone know a method to count the number of lines in a memo field?
Unfortunately, using an algorithm with the len( ) function does not help
because the number of characters contained in a line of text can be quite
variable.

 

[Stephen Lebans]

See:
http://www.lebans.com/limittextinput.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[John Nurick]

Hi Steve,

You'll need something like Stephen's solution if you need to take
account of font size and word wrapping. If you have a linebreak at the
end of each line, however, all you need is something like this, which
will work in a query or a code module:
(Len([XXX])-Len(Replace([XXX], Chr(13) & Chr(10), "")))/2
where [XXX] is the field or variable.