Seperate TXTMSG From Back to Forth!

O

ooxx

hehehe

Dear..

I have things that is to make another field with the seperate text from the
big chunk text. The way is I only need the text from the right count to left
seperate by space and cut it out into anther field.
Thanks
 
G

Graham R Seach

Use the Right() function.
Me!txtTextbox = Right(Me!txtOtherTextBox, 3)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
 
O

ooxx

Thanks!

That's work! And Can Find the specical character space from the right ,
so need not to specific number. In Excel there's a function : find(txt," "),
so any related Function used for this one, and to find it from the right.

Thanks
 
G

Graham R Seach

Yes, to find a specific caharacter or string, from the right, use
InstrRev(). To find it from teh left, use Instr().

iRPos = InstrRev("abcdef", "d", -1)
....or...
iLPos = Instr(1, "abcdef", "d")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
---------------------------
 
O

ooxx

Come BACK

Sorry For LATE REPLY
There is something different or something wrong of the outcomes:
As tested , finally, with the use of right() functhion cut word out from big
text with spaces . The difference is when use this function in the fom of
textbox it out as it was, but when to use to store into parameter for later
use it made obviously come out weird as one character count from left as that
way. So ... any idea..
Thanks
 
G

Graham R Seach

You should show me what you're using now, because you haven't indicated
exactly what the problem is.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
---------------------------
 
Top