Visible/Invisible Lines

[cihow81]

Hi,

I was wondering if anyone knows how to make the lines invisble when there is no input to the control source. I have draw a line below a field inside my report, and when there is no value or null value for that particular field, i want the line to become invisble also... anyone knows how to do it???

 

[Brianwarnock]

You would need to place code in the on format event of the relevent section of the report.

Brian

 

[cihow81]

Hi,

Which part of format of the section should i look out for? And what code do i add in? I am relatively new to Access.

 

[Brianwarnock]

Your control (field) is probably in the detail section of the report so in design view right click the detail header select properties select event tab select format select the... code select code builder and enter code similar to

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.fldmine) Then
Me.Line15.Visible = False
Else: Me.Line15.Visible = True
End If
End Sub

Brian

 

[cihow81]

hi,

Thanks a million...

 

[Brianwarnock]

Happy to help

Brian