Try this variation

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


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

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