Counting number of lines in memo field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jaime - 29 Dec 2006 21:16 GMT

Hi folks,
How do I go about displaying the line count of a memo field? I need to
create a report that shows how many lines there are in a memo field for each
record and a total line count at the end of the report. Thanks in advance!!!

Reply to this Message

Marshall Barton - 29 Dec 2006 23:32 GMT

>How do I go about displaying the line count of a memo field? I need to
>create a report that shows how many lines there are in a memo field for each
>record and a total line count at the end of the report. Thanks in advance!!!

No built-in way to do that.

If each line is newline terminated and short enough to not
wrap to multiple lines, then you could just count the
newline sequences in the memo.

That's a pretty unlikely scenario, so you are either out of
luck or you'll have to try using the fTextHeight function at
www.lebans.com

Signature

Marsh
MVP [MS Access]

Reply to this Message

Jaime - 31 Dec 2006 00:19 GMT

Oh... So I'll have to make some routine to count the newlines then...
Alright. I was hoping for an easy answer, but I guess I have to code this one
;) Thanks again!

> >How do I go about displaying the line count of a memo field? I need to
> >create a report that shows how many lines there are in a memo field for each
[quoted text clipped - 9 lines]
> luck or you'll have to try using the fTextHeight function at
> www.lebans.com

Reply to this Message