Jim -

Test for the # first, like this:

IIf(InStr(1, "Description", "#", 1) = 0, "", Mid("Description",
InStr("Description", "#") + 1, Len("Description") - InStr("Description",
"#")))

--
Daryl S


"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