using formulas in text fields
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
|