Yes, form current was what helped me to some degree recently. I also used both of the others as well - however, not getting the result that when the form was filtered... the color change would happen automatically. I have settled on a 'button' that needs to be pressed in order to update the colors as I desire. At any rate, I guess I will just settle on that.
Thanks again 4 your help! Best regards, Martha Matthews --- In [email protected], Eddie Van <[EMAIL PROTECTED]> wrote: > Martha, > I don't have A97 .... > Try events like > - form current > - form before update > - form after update > > On 5/22/05, martha11ces <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > > > > > > > > > > > -- > 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/
