InStrRev
I’ll be darned. I had no idea InStrRev existed in VBA code. It is new in Access 2000 so it’s been around for nine years.
I had to build this function myself in A2.0 or A97 to get the file name from a string which had the path and file. The code needed to find the right most occurrence of “\” back slash. I’ve been happily using my function ever since.
I actually learned something new about Access this year. <smile>