Conditional formatting to a button

[Susan Serbey]

Hi all
Is it possible to add a conditional formatting to a button to change color?


Thanks in advance

[ranman256]

no. but you can change the color based on the data

select case txtBox.value 
    case "A"
       btn.backcolor = vbRed

    case "B"
       btn.backcolor = vbBlue
end select

[Missinglinq]

And it would have to be a Single View Form...not a Continuous View Form.

To do it on a Continuous View Form...you'd have to use a Textbox, and its OnClick Event, tweaked to look like a Command Button...and then you would have to use Conditional Formatting.

Linq ;0)>