Report

  • Thread starter Thread starter Christophe
  • Start date Start date
C

Christophe

Hi,

Is it possible to display a value on a report if it exist
in the field?

Example: my table contains:

sName , ssurname, sRemarks

on the report I have

Name : Value of sName
Surname: Value of sSurname
Remarks: Value of sRemarks

for Remarks I want to display it on the report only if
sRemark is not null

Thanks
 
If the field is null, then obviously nothing will print on the report. You
will, however, get a blank line where the value would go if data did exist.

To prevent the blank line from showing up, go into the field's property box
and set the "can shrink" option to "yes". You will need to do the same for
the detail section's property.

Hope that helps,

Rick B
 
Back
Top