Use variable to set label backcolor

[tuxalot]

I am trying to set the backcolor of a label and am getting a type mismatch. This code fires in the after update event of the combobox.

strColor = vbRed in this example. I have also tried it using hex values. In the underlying table for cboSourceType, Column 3 is a text data type.

    Me!lblColor.BackColor = FFFFFF
    strColor = cboSourceType.Column(3)
    MsgBox strColor
    Me!lblColor.BackColor = strColor

[Stewart Ross]

In line 1 you need to tell VBA interpreter that the value concerned is hex using the &H operator:

Me!lblColor.BackColor = &HFFFFFF

-Stewart

[Rabbit]

vbRed is just a constant for the number 255. Convert your colors to its corresponding base 10 number.

[Stewart Ross]

Another comment about your original code segment is that the Backcolor property is numeric. Although Access often converts types on the fly you mention that the column in your combo you are using is text. I'd suggest you use the Val function to convert the value explicitly to a numeric value.

-Stewart

[tuxalot]

Thanks for the advice.

[NeoPa]

Also, VBA has a whole bunch of colour constants defined for use - including vbBlack, vbWhite, vbRed, vbBlue, ... The list goes on. Code is far neater if such mnemonics are used in place of literal numbers with no obvious connection to their use.