how many lines in a memo field?

[cliff7376]

Is there a way to find out how many lines or carriage returns are in a memo field?

 

[Travis]

You can find out how many carriage returns are in a memo field by using:

Access 2000 and Up
The Split function and getting the Ubound+1 of the Array

Access 97 and before
See Knowledge base Article:

HOWTO: Simulate Visual Basic 6.0 String Functions in VB5
ID: Q188007

 

[cliff7376]

I need to use the carriage return or line feed as the delimiter. could you tell me what the code is for a carriage return. i.e what i need to put in the delimiter part of the function please.
thank you very much

 

[Travis]

Try vbCrLf or Chr(13) & Chr(10)

 

[cliff7376]

WORKED GREAT THANK YOU