background label color?

[blad3runn69]

ms 97
howto call from a label box? thank you :)

Sub Form_Current()
Dim curAmntDue As Currency, lngBlack As Long
Dim lngRed As Long, lngYellow As Long, lngWhite As Long

If Not IsNull(Me!txtPa stDue.Value) Then
curAmntDue = Me!txtPastDue.V alue
Else
Exit Sub
End If
lngRed = RGB(255, 0, 0)
lngBlack = RGB(0, 0, 0)
lngYellow = RGB(255, 255, 0)
lngWhite = RGB(255, 255, 255)
If curAmntDue > 100 Then
Me!txtPastDue.B orderColor = lngRed
Me!txtPastDue.F oreColor = lngRed
Me!txtPastDue.B ackColor = lngYellow
Else
Me!txtPastDue.B orderColor = lngBlack
Me!txtPastDue.F oreColor = lngBlack
Me!txtPastDue.B ackColor = lngWhite
End If
End Sub


^from ms... how to call this?
from http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
thank you
u know i luv u :)

[pod]

What is it that you want to do and what are you working with?

Be a bit more descriptive about your request.

[missinglinq]

What do you mean by "call?" The Sub Form_Current() event fires when you move from one record to another record, no calling needed.

Linq ;0)>

[blad3runn69]

ah ok thanks missinglinq as always your help is always muchly appreciated

[missinglinq]

Glad we could help!

Linq ;0)>