Field visibility in a report

[PhilTFC]

I am using Access 2007 and have a question for my report.
If a field has a null value on my report how can i make the field not show in print view? but when there is a figure then the field will show on the report.

the control source is CARRIAGE and the label is Label39

i was trying to do a if then else statement but not having much luck



Thank you in advance

[alansidman]

You could try this:

Private Sub Report_Load()
If IsNull(Me.Text0) Then
Me.Text0.Visible = False
End If
End Sub

Be sure to change the names of your controls and reports to reflect your db.

[PhilTFC]

Thank you for your quick reply. I know it is something obvious but i cant see what it is.. the field is not visible on the whole report, this is the VBA i used

Private Sub Report_Load()
If IsNull(Me.Text122) Then
Me.Text122.Visible = False
End If
End Sub

[alansidman]

I mis understood your request. I assumed (my bad) that you had only one record per report. This bit of code says that if any record is null upon loading then the control is not visible.

Is each record on a separate page of the report. Not sure if doing a load on a page (even if it is available) would work. Need to rethink. Hopefully, someone with a little more expertise on reports will jump in here.

Alan

[alansidman]

I did a google search on "MS Access Reports Hide Empty Fields" and found this

http://en.allexperts.com/q/Using-MS-...pty-fields.htm

[PhilTFC]

i am creating an invoice summary which has multiple fields for different customers. thank you for your help and replying so quick.

[PhilTFC]

Awesome!! thank you for taking the time to do a search

[PhilTFC]

not sure how to mark it "solved"

[alansidman]

At the top of the first thread. Thread tools. Marked it for you.