Thank you both for the quick responses - Bob's code worked great!

"Bob Barrows" wrote:

Jim wrote:
I'm using the code below to display everthing after the pound sign
(#) and it works for the most part, but displays the whole field for
fields that don't have a pound sign.

My goal is to display everything after the # if there is a #,
otherwise leave the field blank.

Mid([Description],InStr([Description],"#")+1)

Thanks,
Jim

You will need to use Iif:

Iif(InStr([Description],"#")
0,Mid([Description],InStr([Description],"#")+1))

--
HTH,
Bob Barrows


.