Printing ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm tryin to not print a label on a report if the field fld_temp is null. I
tried the following in the on open of the report, but it doesn't work

If [fld_temp] Is Null Then
ActualSize.[L1] = "0"
 
Sash said:
I'm tryin to not print a label on a report if the field fld_temp is null. I
tried the following in the on open of the report, but it doesn't work

If [fld_temp] Is Null Then
ActualSize.[L1] = "0"
Click to expand...

Just modify the query that the report is based on to exclude records where
fld_temp is null.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array of Labels 4
create a report based on conditions 9
selecting null with an iif expression in criteria access 2k3 13
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Check box in report 2
Null fields on report 3
Setting fields on exit??? 3
Run-Time Error '94' Invalid use of Null 9

Back
Top