View Single Post
  #1  
Old December 14th, 2006, 07:37 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 18
Default 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