String text manipulation

[justphilip2003]

I have a table field JPEG_Id that contains a base picture file names like "CrNr181v1". The v1 refers to view one (front, back, left profile, etc.). I would appreciate knowing the code to nibbling off the last digit of the string and replacing it with a 2, 3 etc. I will have a Gallery form that will fetch and display the jpeg pictures. Also not all base file names will have more than one view, so I also need to intercept a file not found logic. Is the latter possible? TIA Phil

[June7]

Try:
Left("CrNr181v1", Len("CrNr181v1")-1) & 2

If Dir("drive:\path\filename") = "" Then
MsgBox "File not found"
End If

[justphilip2003]

Wow! Thank you!