Print address labels in Access 2007 -blank field shows as 0

[1021557]

Hi, I have a report to print address labels in Access 2007, it works fine but if any one of the address fields is blank it shows up as 0, I want it to just stay blank. The property can grow is set to yes. Help!

 

[Trevor G]

What you can do is in a query is use iif statements to hide the field if no value is present therefore on the report you end up with is one field called address (or something like that) and it should work, see sample below:

Address: IIf([Booking Address 1] Is Not Null,[Booking Address 1] & Chr(13) & Chr(10),Null) & IIf([Booking Address 2] Is Not Null,[Booking Address 2] & Chr(13) & Chr(10),Null) & IIf([Booking Address 3] Is Not Null,[Booking Address 3] & Chr(13) & Chr(10),Null) & IIf([Booking Address 4] Is Not Null,[Booking Address 4] & Chr(13) & Chr(10),Null) & IIf([Booking Address 5] Is Not Null,[Booking Address 5] & Chr(13) & Chr(10),Null) & IIf([Booking Address 6] Is Not Null,[Booking Address 6] & Chr(13) & Chr(10),Null)