Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Is it possible to enable conditional formatting in VBA code.
    I was thinking of colouring a few rows of a table in a form depending upon a value in the row.
    Is this possible?
    I use Access 2003.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    A control has a FormatConditions property that represents the conditional formatting settings.
    See for example:
    Extending the Functionality of Conditional Formatting in Access
    How to programmatically apply conditional formatting settings to all form controls

    Also see the attachment to Post 382292 for other ways to highlight rows in a continuous form.

Posting Permissions

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