don't print empty fields

[iaqsuk via AccessMonster.com]

I have a Form with multiple fields, if a certain field is empty then I don't
want all fields printed. For Ex.:

EmpName
Address1
Phone
Email

if Employees with no data in Emails don't print all fields? Not all Employees
has e-mails.

The current database prints all Employees fields even with with no data. Do
I need to do a Query? thank you. Arnold

 

[Marshall Barton]

I have a Form with multiple fields, if a certain field is empty then I don't
want all fields printed. For Ex.:

EmpName
Address1
Phone
Email

if Employees with no data in Emails don't print all fields? Not all Employees
has e-mails.

The current database prints all Employees fields even with with no data. Do
I need to do a Query?

If you don't want records to appear in the report, then you
should use a query as the report's record source and the
query should use criteria that excludes the Null address
records.

 

[iaqsuk via AccessMonster.com]

Thank you for your help, that worked. Arnold

I have a Form with multiple fields, if a certain field is empty then I don't
want all fields printed. For Ex.:

[quoted text clipped - 9 lines]

The current database prints all Employees fields even with with no data. Do
I need to do a Query?

If you don't want records to appear in the report, then you
should use a query as the report's record source and the
query should use criteria that excludes the Null address
records.