Count Line Breaks in Memo Field 1

[BattleDroid42]

How would I count the number of line breaks/returns in the text of a memo field?

 

[PHV]

Something like this ?
(Len(MemoField) - Len(Replace(MemoField, vbCrLf, ""))) / Len(vbCrLf)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CajunCenturion]

If you're using A2K or later, then you could try using the Split function on the memo field, using vbCrLf as the delimiter. Then you can determine the number of returns as the UBound(TheArray) - 2.

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[BattleDroid42]

Access assumes that vbCrLf is a field name and places brackets around it. I was hoping to be able to do this in a query rather than in code.

 

[PHV]

And this ?
(Len(MemoField) - Len(Replace(MemoField, Chr(13) & Chr(10), ""))) / 2)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BattleDroid42]

Nice! Bravo!