Eddie - I really appreciate your help. This sounds like a great solution... I never used it - 'cuz Access 97 doesn't have 'Conditional Format.' I tried to find it everywhere. Any other ideas?
I did find a solution in the Developers Solutions CD 4 97. Anyway, I have it working partially. There is something you might be able to help me with... I can get the field to change colors as I want in the event that I update another field (Field 1). I, however, want the colors to change automatically when the content changes. For instance, I have two fields that are sums of other fields and the resulting sum is subtracted from Field 1. On this form, only Field 1 can change (the other two summation fields can only be changed via another form). My resulting field (that I would like to change colors) doesn't change colors when a filter is applied to the summation fields despite adding code instructing it to do so (I know it potentially should work as it works when Field 1 is changed). Do you have any ideas? Thanks Martha Matthews --- In [email protected], Eddie Van <[EMAIL PROTECTED]> wrote: > 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/
