Supressing # if no data in field

[FredK]

I'm sorry that I'm posting this question as it's similar to another question I asked, but I still can't get this to work.

I'm using Access 2003. I'm using the below in a textbox in a report. When there's no data in the field "fars_main_mailing_address_2nd_address" I would like to
supress the #. Otherwise if there is data in the field, I would like it to print the "#".

Thanks for the help.

=[fars_main_mailing_address_nbr] & " " &

[fars_main_mailing_address_street_dir] & " " &

[fars_main_mailing_address_street_name] & " " &

[fars_main_mailing_address_street_type] & " #" &

[fars_main_mailing_address_2nd_address] & " " &

[fars_main_mailing_address_city] & ", " &

[fars_main_mailing_address_state] & " " &

[fars_main_mailing_address_zip]

 

[Marshall Barton]

I'm sorry that I'm posting this question as it's similar to another question I asked, but I still can't get this to work.

I'm using Access 2003. I'm using the below in a textbox in a report.
When there's no data in the field "fars_main_mailing_address_2nd_address" I would like to
supress the #. Otherwise if there is data in the field, I would like it to print the "#".

Thanks for the help.

=[fars_main_mailing_address_nbr] & " " &

[fars_main_mailing_address_street_dir] & " " &

[fars_main_mailing_address_street_name] & " " &

[fars_main_mailing_address_street_type] & " #" &

[fars_main_mailing_address_2nd_address] & " " &

[fars_main_mailing_address_city] & ", " &

[fars_main_mailing_address_state] & " " &

[fars_main_mailing_address_zip]

. . .
[fars_main_mailing_address_street_type] & (" #" +
[fars_main_mailing_address_2nd_address]) & " " &
. . .