Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Question Unanswered: Is it possible - conditional formatting in continious forms?

    Hi everyone,

    Is it possible to make conditional formatting in continious forms?
    I have a form with few textboxes surrounded bu a rectangle.
    On OnLoad event of the Form I put following code:

    IIf Date > Now()
    Than rectangle.backcolor = vbRed
    Else rectangle.backcolor = vbYellow
    End If

    If the Form is in Single Form View it works but in Continious forms it makes all the rows red /or all yellow/.
    Is there another way to make conditional formatting in continious forms?

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    From the form design view choose format - conditionsl formatting.

Posting Permissions

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