not printing null or "0" values

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

Guest

Greetings,

I have a form where the user enters in costs for a certain record and then
can print a contract (report) from the record on screen. Is there a some
code I could use that would not print a feild if it is null or has value of
"0"?

Thanks in advance,

Jason
Paraclete Systems
 
To not print the field if it has a null value, just set the can shrink
property of the field and the section where the field is in to true.
About the zero and the null if you want
On the on print event of the section where the field is, enter the code
if isnull(me.FieldName) or me.Fieldname=0 then
me.FieldName.visible=false
else
me.FieldName.visible=true
end if
 
Back
Top