timming help needed

[JohnE]

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

 

[Al Campagna]

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]

Perfect. Thanks Al.

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."

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