Right Function with InStr

[SurveyorinVA via AccessMonster.com]

Hello,

I have the following text string in a text box Path1:
P:\Projects\059401.00\survey\Fnotes\09-11-07\Crew 1\SR3-091107.crd

I would like to return the following as MyText: SR3-091107.crd

I am trying to use this
MyText = right(Me.path1, Len(Me.path1) - InStr(Me.path1, "\") - 1) but is not
returning the string.

I know that the InStr evaluates from the Left, but is there a function to
evaluate to a certain character is reached from the right?

Any help or points in the right direction would be greatly appreciated.

Thank You in advance,
Chris

 

[Guest]

Better to use the Mid function for this:

Me.MyText = mid(Me.path1,instrrev(Me.path1,"\")+1)

 

[tobesurveyor via AccessMonster.com]

Works like a charm, thank you!

Better to use the Mid function for this:

Me.MyText = mid(Me.path1,instrrev(Me.path1,"\")+1)

Hello,

[quoted text clipped - 14 lines]

Thank You in advance,
Chris