Suppressing the # in a string if there's no data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm using Access 2003 and I'm trying to print an address on a letter. I
have a data field named "mailing_address_apt". When there's data in the
field, I'd like to have the "#" print in front of the data. And when there
is no data in the field, I don't want the "#" to print.

I'm using the below string, but it always prints the "#" whether there's
data or not.

=[mailing_address_street_name] & " #" & [mailing_address_apt]



Any help would be appreicated.


.