Blank Lines in Report

[Con Giacomini]

Microsoft Knowledge Base Article #209653 describes a method to eliminate
blank lines in a form or report using the following text box properties:

=IIf(IsNull([FirstName]),"",[FirstName] & " ") & _
IIf(IsNull([LastName]),"",[LastName]& Chr(13)& Chr(10)) & _
IIf(IsNull([ADDRESS]),"",[ADDRESS] & Chr(13) & Chr(10)) & _
IIf(IsNull([CITY]),"",[CITY] & ", ") & _
IIf(IsNull([REGION]) ,"",[REGION] & " ") & _
IIf(IsNull([PostalCode]),"",[PostalCode])

When I attempt to use it in Northwind.mdb it produces an error message
stating "Extra ) in query expression....."

I am trying to adapt this to my database and have not been able to find the
extra ). Help is appreciated.

 

[Douglas J. Steele]

Make sure you have spaces before (and after) all the ampersands (&).

It's possible that Access is treating it as the type-declaration character
for Long Integer.