You can use conditional formatting to have a button change do different colors under different conditions. I don't believe there's a way to dynamically change the screen tip on a control.
Jimmy Rishe / Software Developer / Microsoft MVP
Qdabra Software