Results 1 to 4 of 4

Thread: Change the color of a row in a form if criteria is met
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2016
    Posts
    124
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Change the color of a row in a form if criteria is met

    Can anyone tell me how I can change the color of row data in my form if it meets this criteria and how would I create the query if it already has a select statement that populates the form...

    * Distribution Type: In-Service Withdrawal
    * Disbursement Amount: $50,000.00 or more
    * Disbursement Method: ACH Transfer

  2. #2
    Board Regular
    Join Date
    May 2013
    Posts
    594
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Change the color of a row in a form if criteria is met

    You could apply the same expression to all controls in the row using conditional formatting ?
    Or use Crystal's method.

    https://www.youtube.com/watch?v=2ArtsDJrK7k
    Last edited by welshgasman; May 9th, 2019 at 03:45 PM.
    Office 2007
    Access novice. Sometimes trying to give something back

  3. #3
    Board Regular
    Join Date
    Jun 2016
    Posts
    124
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Change the color of a row in a form if criteria is met

    Quote Originally Posted by welshgasman View Post
    You could apply the same expression to all controls in the row using conditional formatting ?
    Or use Crystal's method.

    https://www.youtube.com/watch?v=2ArtsDJrK7k

    So, I can apply all 3 criteria's within the expression in conditional formatting and if so, how would I write the expression in order to meet the 3 criteria's:


    If any row meets this criteria:
    * Distribution Type: In-Service Withdrawal
    * Disbursement Amount: $50,000.00 or more
    * Disbursement Method: ACH Transfer
    Then highlight those specific rows....

  4. #4
    Board Regular
    Join Date
    May 2013
    Posts
    594
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Change the color of a row in a form if criteria is met

    It depends on how many controls you have to whether you do it individually or use Crystal's method.? Up to 5 I'd probably do them individually, any more I'd put in the extra control and do it Crystal's way. The expression would be the same either way?

    You build the expression just the same as if you did it in VBA but without the If and with []

    [Amount] > 50000 AND .......
    Office 2007
    Access novice. Sometimes trying to give something back

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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