Thread: using formulas in text fields
View Single Post
  #5  
Old December 14th, 2006, 09:28 PM posted to microsoft.public.access.forms
fredg
external usenet poster
  
Posts: 4,386
Default using formulas in text fields
On Thu, 14 Dec 2006 20:16:02 GMT, wrote:

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

On Thu, 14 Dec 2006 15:04:57 -0500, "Douglas J. Steele"
wrote:

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
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail