timming help needed

  • Thread starter Thread starter JohnE
  • Start date Start date
J

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
 
Perfect. Thanks Al.


Al Campagna said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top