Mystr=right question

G

Golfinray

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!!!!!!!
 
O

Ofer Cohen

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
 
G

Golfinray

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...
 
Top