want to print only actual data

[Nadalia]

I used form wizard to create a data entry form based on a table. The database user wants to print the form that only show the data fields that have information in them. For the data fields that have no information, they dont want them show up on the form at all. How do I set the condition something like if datafield1 is null, then disappear, else, show on the form.

Thanks!!!

 

[FoFa]

You have to set the visible property for that control (data field) to false, and usually it's associated label also.

 

[Nadalia]

You have to set the visible property for that control (data field) to false, and usually it's associated label also.

FoFa, I opened the form in design mode, clicked on the data field and found "visible" property, but there is only "yes" "no" you can choose, no "false". I tried to set the visible to "no", the field just totally disappeared from the form no matter there is information or not.

Any ideas?

Thanks,

Nadalia

 

[Pat Hartman]

Forms are not optimized for printing. They do not expose the events you need to control visibility at print time. Create a report and print that. In the Format event of the detail section, you can hide/show fields:

If IsNull(Me.SomeField) Then
    Me.SomeField.Visible = False
    Me.SomeField_lbl.Visible = False
Else
    Me.SomeField.Visible = True
    Me.SomeField_lbl.Visible = True
End If