Remove the first line form a Memo box 1

[jmc014]

I could do with a little help if some's got the time..

While I'm able to capture the frst line of text from my Memo Box, I would like to know if there is a way to capture the entire text form my memo box EXCEPT for the first line.

Here's the code that I use to capture the first lime of text:
MyCapture = Left([MyMemoBox], InStr(1, [MyMemoBox], vbCrLf) - 1)

Or... What's the best way to remove the first line from a memo box (which is what I'm trying to do)

Thanks for help.
JMC

 

[SkipVought]

MyCapture = Right([MyMemoBox], Len([MyMemoBox]) - InStr(1, [MyMemoBox], vbCrLf) + 1)


Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Andrzejek]

Or:
[tt]
MyCapture = Mid([MyMemoBox], InStr(1, [MyMemoBox], vbCrLf) + 1)
[/tt]

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

@Andy, regarding your "stations:" Might stationary stationery be somewhat like write only memory?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[jmc014]

MAGIC...

Thank you.
JMC