Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    What Form event to use to run procedure?

    I have a database which data is downloaded rather than manually entered. A form is used to display the data. Some test results have a comment such as "High" or "Low". When one of these comments appears I wanted to change the fore color of the text, but I can't figure out which form event to use to run the code. Since there is no editing or data entry the control events are out.

    Any ideas?
    Last edited by chuckrau; 2016-06-07 at 22:06. Reason: Used the wrong word
    Thanks
    chuck

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Chuck,

    Current : Occurs when the focus moves to a record, making it the current record, or when the form is refreshed or requeried.
    Source: MSDN

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post
    Works perfectly! Thank you very much.
    Thanks
    chuck

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    Do you know about conditional formatting? This can handle your situation without any code.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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