By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,080 Members | 1,855 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,080 IT Pros & Developers. It's quick & easy.

background label color?

P: 59
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!txtPastDue.Value) Then
curAmntDue = Me!txtPastDue.Value
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.BorderColor = lngRed
Me!txtPastDue.ForeColor = lngRed
Me!txtPastDue.BackColor = lngYellow
Else
Me!txtPastDue.BorderColor = lngBlack
Me!txtPastDue.ForeColor = lngBlack
Me!txtPastDue.BackColor = 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 :)
May 30 '08 #1
Share this Question
Share on Google+
4 Replies


pod
100+
P: 298
pod
What is it that you want to do and what are you working with?

Be a bit more descriptive about your request.
May 30 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
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)>
May 30 '08 #3

P: 59
ah ok thanks missinglinq as always your help is always muchly appreciated
May 30 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
May 31 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.