Seperate TXTMSG From Back to Forth!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the Right() function.
Me!txtTextbox = Right(Me!txtOtherTextBox, 3)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
 
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
 
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)
---------------------------
 
Back
Top