Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: Joining two conditions in conditional formatting

    Hello!!!!

    Can anybody please help me. I have a problem how to join two conditions in conditional formatting. I'm using access 2000.
    It's like that: I have two fields in subform A and B. And I wan't that if the field A=12 and the field B(date format) is between date and date+30 that the field B becomes red.

    Thank for your help

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: Joining two conditions in conditional formatting

    You have 4 move buttons correct?

    MoveFirst, MoveNext, MovePrevious and MoveLast

    In their events check the values of A and B if they match your criteria change the color of the textbox that is bound to your field.

    Try this control which lets you do all that easily:

    http://www.geocities.com/scirocco_ha/DataControl.htm

    Originally posted by cuc
    Hello!!!!

    Can anybody please help me. I have a problem how to join two conditions in conditional formatting. I'm using access 2000.
    It's like that: I have two fields in subform A and B. And I wan't that if the field A=12 and the field B(date format) is between date and date+30 that the field B becomes red.

    Thank for your help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •