Thanks 4 looking at this 4 me. I checked and indeed it does work on a field that one enters data into. However, (and I believe this might help you help me figure it out) - it does not work in a field that sums up a # of other fields. Maybe that was what the problem was. Any ideas?
--- In [email protected], Eddie Van <[EMAIL PROTECTED]> wrote: > Works here ... I don't see why it wouldn't work for you..... sorry > > On 5/22/05, martha11ces <[EMAIL PROTECTED]> wrote: > > Yes - there is a reason 4 this. I can change it the other way - if > > need be. I really just want it to work. Right now it doesn't work at > > all. > > > > Any suggestions? > > > > Thanks, > > > > Martha Matthews > > > > > > --- In [email protected], Eddie Van <[EMAIL PROTECTED]> wrote: > > > Martha, > > > The code shows positive numbers in red, and negative numbers in > > black. > > > But is that what you want ? > > > > > > On 5/22/05, martha11ces <[EMAIL PROTECTED]> wrote: > > > > Can anyone take a moment to help me figure out what I am doing > > wrong > > > > here. I've gotta be close... > > > > > > > > Private Sub OverUnder1_AfterUpdate() > > > > > > > > If Me!OverUnder1.Value >= 0 Then > > > > Me!OverUnder1.ForeColor = 255 > > > > > > > > Else > > > > Me!OverUnder1.ForeColor = 0 > > > > > > > > End If > > > > End Sub > > > > > > > > Did I put the code in the right place? or? > > > > > > > > Thanks 4 any help, > > > > > > > > M. Matthews > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > Eddie > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > -- > Eddie Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
