[AccessD] Setting Back Color of a label

Sat Apr 8 23:41:56 CDT 2017

Dear List(s):

In the after update event of an option control I test it and set the back
color of a label to green(ish) if True and red(ish) if false.

The red(ish) color is #FFA3A3 which is the default color set in the property
sheet.  The gren(ish) color is #DCFCDC.

The code:

    If Me.fldSCOTaskCompleteConfirmGo = True Then

       ' Make It Green

        Me.lblConfirmCRSIsaGofromCLNT.BackColor = &HDCFCDC

    Else

       ' Make It Red

        Me.lblConfirmCRSIsaGofromCLNT.BackColor = &HFFA3A3

    End If

Changing the option control from false to true turns the back color of the
label green(ish). Good!

Changing the option control from true to false changes the back color of the
label not ref but to purple(ish). Bad!

Google has failed me.

Does anyone know why this difference between the color in the property sheet
and setting it through VBA?

MTIA

Rocky Smolin

Beach Access Software

760-683-5777

 <http://www.bchacc.com> www.bchacc.com

 <http://www.e-z-mrp.com> www.e-z-mrp.com

Skype: rocky.smolin