Trimming text box

[Lenny]

I collect a path (C:\My files\Joe\JoeReport.doc)in a text
box, programmatically. I would like to create another
text box or label, that would show only the file name
(JoeReport) or (JoeReport.doc), without showing the entire
path. Any help is greatly appreciated.

 

[RobFMS]

Here's one suggestion:

Use the InStrRev() OR strReverse() Function to Extract the Path from a File
Name
http://www.fmsinc.com/free/tips.html#Access2000+

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Lenny]

Thanks Rob. I can't figure out the proper syntax for that
function

 

[RobFMS]

Both of these functions are in Access 2000 (and up). Check the help file for
more specifics.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-