using formulas in text fields

[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

 

[everymn]

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

 

[Douglas J. Steele]

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

 

[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

 

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

Make sure the name of the control is NOT f5

 

[everymn]

On Thu, 14 Dec 2006 13:28:35 -0800, fredg <[email protected]>
wrote:

This was the problem thanks.