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/
