text box back color change

[lane55]

I have a form with two general number text boxes one
contains a formula the other is just a number. I am trying
to change the backcolor of text1 if it is greater than text2.
On afterupdate of text1 I have
IF Me![text1] > Me![text2] Then Me.text1.backcolor = 1677215

Nothing happens, what am I missing?

 

[Steve Schapel]

Lane,

Shooting in the dark here...
Is the value of Text2 dependent on the value of Text1? If so, the After
Update event of Text1 might be too early to try the comparison. Another
thought... maybe the Back Style property of Text1 is set to Transparent.

 

[Lane 55]

After update was too early for the comparison. Thanks for
your help. Lane55

-----Original Message-----
Lane,

Shooting in the dark here...
Is the value of Text2 dependent on the value of Text1? If so, the After
Update event of Text1 might be too early to try the comparison. Another
thought... maybe the Back Style property of Text1 is set to Transparent.

--
Steve Schapel, Microsoft Access MVP

I have a form with two general number text boxes one
contains a formula the other is just a number. I am trying
to change the backcolor of text1 if it is greater than text2.
On afterupdate of text1 I have
IF Me![text1] > Me![text2] Then Me.text1.backcolor = 1677215

Nothing happens, what am I missing?

.