• What Form event to use to run procedure?

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » What Form event to use to run procedure?

    • This topic has 3 replies, 3 voices, and was last updated 9 years ago.
    Author
    Topic
    #505818

    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?

    Viewing 1 reply thread
    Author
    Replies
    • #1566838

      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 :cheers:

      May the Forces of good computing be with you!

      RG

      PowerShell & VBA Rule!
      Computer Specs

    • #1567447

      Do you know about conditional formatting? This can handle your situation without any code.

    Viewing 1 reply thread
    Reply To: Reply #1566893 in What Form event to use to run procedure?

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel