using formulas in text fields

E

everymn

Hi,

I have a large text field from which I'd like to display only the last
5 characters. I thought the way to do this would be to set the
control source to this:

=Right$([f5],5)

but it's giving me #Error. If I just set it to [f5] then the full
text displays so the source is good but evidently I'm phrasing it
wrong. Could someone tell me what the correct syntax is?

Thank You
 
E

everymn

My bad. This is actually not a text field but a memo field. Can one
not use text methods on memo fields?
 
D

Douglas J. Steele

Does the field always have a value? If it's ever Null, then Right$ will
fail: use Right instead.
 
E

everymn

I tried that one, same thingr. I know that there is something in this
field though. Something about the way I'm phrasing it must be wrong

I've tried it like this:
=[Right([f5],5)]

and this
=Right([f5],5)

and this
=Right(f5,5)

always yields #Error
 
F

fredg

I tried that one, same thingr. I know that there is something in this
field though. Something about the way I'm phrasing it must be wrong

I've tried it like this:
=[Right([f5],5)]

and this
=Right([f5],5)

and this
=Right(f5,5)

always yields #Error

Does the field always have a value? If it's ever Null, then Right$ will
fail: use Right instead.
Click to expand...
Click to expand...

Make sure the name of the control is NOT f5
 
Top