Mystr=right question

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

Guest

I figured out how to write the expression I want to use
mystr=right([schoolname],8) but I have tried entering it everywhere in the
properties for the textbox and no work. I just have a field in a textbox that
I want to return the right-most 8 characters or I could just eliminate the
left-most 5 characters (they are numbers, not text.) Where or how??? Thanks
so much!!!!!!!
 
In the text box Control Source property write

=Right([schoolname],8)

droping the mystr, and assuming that schoolname is a name of a field in the
record source of the form
 
Thank You!!!

Ofer Cohen said:
In the text box Control Source property write

=Right([schoolname],8)

droping the mystr, and assuming that schoolname is a name of a field in the
record source of the form

--
Good Luck
BS"D


Golfinray said:
I figured out how to write the expression I want to use
mystr=right([schoolname],8) but I have tried entering it everywhere in the
properties for the textbox and no work. I just have a field in a textbox that
I want to return the right-most 8 characters or I could just eliminate the
left-most 5 characters (they are numbers, not text.) Where or how??? Thanks
so much!!!!!!!
Click to expand...
Click to expand...
 
Back
Top