1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| Option Compare Database
Private Sub Détail_Format(Cancel As Integer, FormatCount As Integer)
Me.COD_EXT_GPE.BackColor = 16777215
Me.LIB_GPE.BackColor = 16777215
Me.TEM_GPE_AFF.BackColor = 16777215
Me.TEM_CAP_MAX_BLO.BackColor = 16777215
Me.CAP_INT_GPE.BackColor = 16777215
Me.CAP_MAX_GPE.BackColor = 16777215
Me.EFF.BackColor = 16777215
Me.RESTE.BackColor = 16777215
If (Me.TEM_GPE_AFF = "N" Or Me.TEM_GPE_AFF = Null) Then
Me.COD_EXT_GPE.BackColor = RGB(0, 183, 239)
Me.LIB_GPE.BackColor = RGB(0, 183, 239)
Me.TEM_GPE_AFF.BackColor = RGB(0, 183, 239)
Me.TEM_CAP_MAX_BLO.BackColor = RGB(0, 183, 239)
Me.CAP_INT_GPE.BackColor = RGB(0, 183, 239)
Me.CAP_MAX_GPE.BackColor = RGB(0, 183, 239)
Me.EFF.BackColor = RGB(0, 183, 239)
Me.RESTE.BackColor = RGB(0, 183, 239)
End If
If val(Me.RESTE) = 0 Then
Me.COD_EXT_GPE.BackColor = 255
Me.LIB_GPE.BackColor = 255
Me.TEM_GPE_AFF.BackColor = 255
Me.TEM_CAP_MAX_BLO.BackColor = 255
Me.CAP_INT_GPE.BackColor = 255
Me.CAP_MAX_GPE.BackColor = 255
Me.EFF.BackColor = 255
Me.RESTE.BackColor = 255
End If
If val(Me.RESTE) < 5 And val(Me.RESTE) > 0 Then
Me.COD_EXT_GPE.BackColor = 65535
Me.LIB_GPE.BackColor = 65535
Me.TEM_GPE_AFF.BackColor = 65535
Me.TEM_CAP_MAX_BLO.BackColor = 65535
Me.CAP_INT_GPE.BackColor = 65535
Me.CAP_MAX_GPE.BackColor = 65535
Me.EFF.BackColor = 65535
Me.RESTE.BackColor = 65535
End If
End Sub |
Partager