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.