Blank Lines in Report

  • Thread starter Thread starter Con Giacomini
  • Start date Start date
C

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.
 
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.
 
Back
Top