timming help needed JohnE 11/20/2008 8:29:07 PM I have a click value from a treeview going into a txtbox. The treeview has the ID number, space, space, name. In the txtbox I need to only show the name. Currently there are 3 in front of the name. There will be more in front of the name as the ID gets larger. How would I be able to remove what's in front of the name? Thanks. .... john

Re: timming help needed "Al Campagna" <newsgroups[ at ]comcast.net> 11/21/2008 4:48:45 AM JohnE, As long as there's always 2 spaces.. =Mid([YourField], InStr([YourField, " ") +2) -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "JohnE" <JohnE[ at ]discussions.microsoft.com> wrote in message news:6FC683FD-D2F0-40CD-87EF-35CDAB9E5055[ at ]microsoft.com... [Quoted Text] >I have a click value from a treeview going into a txtbox. The treeview has > the ID number, space, space, name. In the txtbox I need to only show the > name. Currently there are 3 in front of the name. There will be more in > front of the name as the ID gets larger. > How would I be able to remove what's in front of the name? > Thanks. > ... john

Re: timming help needed JohnE 11/21/2008 6:34:01 PM Perfect. Thanks Al. "Al Campagna" wrote: [Quoted Text] > JohnE, > As long as there's always 2 spaces.. > =Mid([YourField], InStr([YourField, " ") +2) > -- > hth > Al Campagna > Microsoft Access MVP > http://home.comcast.net/~cccsolutions/index.html > > "Find a job that you love... and you'll never work a day in your life." > > "JohnE" <JohnE[ at ]discussions.microsoft.com> wrote in message > news:6FC683FD-D2F0-40CD-87EF-35CDAB9E5055[ at ]microsoft.com... > >I have a click value from a treeview going into a txtbox. The treeview has > > the ID number, space, space, name. In the txtbox I need to only show the > > name. Currently there are 3 in front of the name. There will be more in > > front of the name as the ID gets larger. > > How would I be able to remove what's in front of the name? > > Thanks. > > ... john > > >