jessabridge
Registered User.
- Local time
- Today, 15:37
- Joined
- Jun 29, 2011
- Messages
- 35
I have:
Option Compare Database
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Overtime = 0 Then
Me.OT.BackColor = vbBlack
Me.OT.Visible = False
End If
End Sub
And it is working, but:
I need 5 other statements like this that are not contingent on each other.
If Me.Personal_DayTable = 0 Then
Me.P.BackColor = vbBlack
Me.P.Visible = False
End If
Is it even possible? My first time in Basic...shocked I got one to run.
Thanks in advance!
Jessa
PS...I just nothice the "if" only worked on the first data subset... So, I guess I don't want the "if" to end....is that possible?
Option Compare Database
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Overtime = 0 Then
Me.OT.BackColor = vbBlack
Me.OT.Visible = False
End If
End Sub
And it is working, but:
I need 5 other statements like this that are not contingent on each other.
If Me.Personal_DayTable = 0 Then
Me.P.BackColor = vbBlack
Me.P.Visible = False
End If
Is it even possible? My first time in Basic...shocked I got one to run.

Thanks in advance!
Jessa
PS...I just nothice the "if" only worked on the first data subset... So, I guess I don't want the "if" to end....is that possible?
Last edited: