report if a field were null it would not display

[Guest]

Hi

I have a table linked to a form. If that form were to have a field with a
null value, how would I eliminate it being printed in the report? Can I set
up a query to do this?

Cheers,
Damian

 

[Allen Browne]

Yes. In query design view, under the field that could be null, enter:
Is Not Null

 

[John Vinson]

Hi

I have a table linked to a form. If that form were to have a field with a
null value, how would I eliminate it being printed in the report? Can I set
up a query to do this?

A Form is used for onscreen viewing. A Report is used for printing.
They are different objects. I'm not certain just what you want!

If a field has a null value, it will print as blanks in a report.
Unless you have set the properties of the textbox printing the field
to something other than the default, you'll see nothing on the paper.
Could you give an example of what you mean by "not printed in the
report"?


John W. Vinson[MVP]