backcolor change

[lee123]

is it possible to change the backcolor of a text box certain color for instance
let say that a text box is formatted in currency and you wanted to make the color of the backcolor vbyellow if it's under a hundred dollars and if the currecy is over five hundred dollars you would make it another color and the final one is if it's over 1000 dollars another color. because i tried to do this in an (if statement) but everytime i did the first color would show (under 100 dollars) then when i did the over 500 dollars it would change. but how do you do it if it's over 1000 dollars because when i did it would be the color i have selected for the one (over 500 dollars)

[missinglinq]

I've picked some arbitrary colors here for demonstration purposes. You can change them to whatever you want, of course. You need to change CurrencyField to whatever you actually call yours!

Private Sub CurrencyField_AfterUpdate()
If CurrencyField < 100 Then
 CurrencyField.BackColor = vbYellow
ElseIf CurrencyField > 500 And CurrencyField <= 1000 Then
 CurrencyField.BackColor = vbRed
ElseIf CurrencyField > 1000 Then
CurrencyField.BackColor = vbBlue
Else
CurrencyField.BackColor = vbWhite
End If
End Sub

Where exactly are you placing this code?

Linq ;0)>

[lee123]

in the form itself (on current) i almost had it right but looking at your code i forgot somethings Like this line:

ElseIf CurrencyField > 500 And CurrencyField <= 1000 Then

i forgot to add the:

And (CurrencyField) twice

thanks for the info.

lee123

[missinglinq]

That's a common mistake! Glad we could help!

Linq ;0)>