count line in memo(multi line text)

#1 (**permalink**) 28-Jul-2006, 08:16 AM

I want cod of(count line in memo text(multi line text) )
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10876-count-line-memo-multi-line-text.html

*

#2 (**permalink**) 28-Jul-2006, 08:16 AM

Since lines are separated by a combination of Carriage Return/Line Feed
(Chr$(13) & Chr$(10), in that order), you can use the following:

(Len([MyMemoField]) - Len(Replace([MyMemoField], Chr$(13) & Chr$(10),
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10876
"")))/2

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"yousef" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10876
news:A1D3DBC0-92FB-44A2-A167-9A9B386F24B6@microsoft.com...
> I want cod of(count line in memo text(multi line text) )

#3 (**permalink**) 28-Jul-2006, 08:16 AM

yousef wrote:
> I want cod of(count line in memo text(multi line text) )
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10876
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10876

Remember that "lines" are defined with a carnage return and line feed.

The lines displayed at any given time may include wrapped lines that
depend on the width of the control in which they are being displayed.

--
Joseph Meehan

Dia duit