Change Bordercolor of a form

[merc_slk]

Hello,

Depending on what the user can do I want to change the bordercolor of my form.
RED - New Record
YELLOW/ORANGE - Record being edited
Green - Record on page completed, ready to save.

Many thanks,

Jef

 

[DCrake]

Once you have laid down the rules that determine the colour change then use the

Me.BorderColor = vbWhateverColor in the forms OnCurrent Event

David

 

[JPaulo]

Simple my invention.

See the att

 

[merc_slk]

All nice but there is still a difference between changing the bordercolor of an object (textbox,combobox,listbox, etc) @ JPaulo on a form, quite easy than changing the bordercolor of it's form self. The only thing you can change is me.borderstyle @ DCrake or a global setting for all your windows through desktop settings(that's not what i want).

I search a possibility to change the bordercolor of an active form(window) individually not the objects on a form.

Little bit more difficult guys.

 

[JPaulo]

Sorry did not see who was the form, but it will be difficult.