Results 1 to 5 of 5
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    From a database i have inherited, I have noticed that any forms background colours are white until the cursor is put into the control when the background changes to yellow?
    This doesn't happen for all controls though just the majority.
    There is no code to change this background colour or at least i cannot see it.
    Can anybody shed some light?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Pat

    Conditional Formatting can be used to do that.

    [attachment=88794:conditionalFormat.gif]
    Attached Images Attached Images
    Regards
    John



  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Spot on John, I didn't think to look at that, silly me.

    You may as well cancel the one over the other side as well.

    Pity MS didn't provide an option to make all controls in a form like that with exclusions, this makes development that much quicker. There are quite a few forms with tabs and many controls, to do that manually takes a lot of time.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    You can apply Conditional Formatting to multiple controls at once, provided they all start with the same formatting.
    Regards
    John



  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    I didn't know that duh, but it makes a lot of sense.

    Thanks again John

Posting Permissions

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