Line Visibility property change based on field value (1 Viewer)

virencm

Registered User.
Local time
Today, 17:45
Joined
Nov 13, 2009
Messages
61
Hi

I need the visibility of a line to change based on a field value

Line : Line241(Visible property set to "NO")
Field : Notes4

The code below does not seem to affect the visibility of the line241

Please Help!

Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Notes4.Value = "Note: No Action Req'd for this Engine" Then
Me.Line241.Visible = True
Else
End If
End Sub
Code:
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 23:45
Joined
Aug 30, 2003
Messages
36,118
That should work, though you need to set it to False in the Else clause. Can you post a sample of the db here?
 

virencm

Registered User.
Local time
Today, 17:45
Joined
Nov 13, 2009
Messages
61
Hi Paul

Thanks for a quick reply

Attached is a sample db. When opening report (print preview), input "5401" in first parameter and leave the next two parameter's blank,
 

Attachments

  • Sample.zip
    414.7 KB · Views: 113

virencm

Registered User.
Local time
Today, 17:45
Joined
Nov 13, 2009
Messages
61
Paul

I had to set the visible property to false in the else clause. Thanks for your help
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 23:45
Joined
Aug 30, 2003
Messages
36,118
Happy to help.
 

Users who are viewing this thread

Top Bottom