Umm.

Guys I have a Program that uses a database and I have it so when they click on a button it comes up with everything in the row they selected and each string is seperated with a space how do I get it so that it just displays the stuff after the last space and not anything else.
It is like this:
ddsfkdf fdkjfd fdjvdfs thisiswhatiwant

how do I get it so it only displays

thisiswhatiwant in the msgbox instead of the other stuff

or better yet get the data from just that cell (I use adodc and the data grid to access my MDB) if anyone knows how to get data directly from a cell it would be more apprciated than giving a code to sift through the whole string

Thanks

(I hope that is not to complicated)

[Edited by absalom on 11-17-2000 at 11:22 PM]