Martha, Let's recap. You want the field OverUnder1 to have a black forecolor if the value is negative, red forecolor if the value is positive. In design mode, set the field's OverUnder1 forecolor to red. Then, in the menu, click on Format/Conditional Format. Set the fields to : Field value is ..... less than ... 0 ...... and choose black on the icon for the character color. Click OK. You can play around with this conditional format, which comes in handy sometimes.
On 5/22/05, martha11ces <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > -- 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/
