Changing borderColor with a button

D

Dan H.

In a previous question I was show how to change the color and thickness of a
border with a button and it work great. However two problem have come up.
first I noticed the after I change the bordercolor save and then exit the
form the border defult back to the way it was. How can I prevent this.
Second unlike Conditional Formating the change does not carry over to the
report section is there an easy way to have the chang flow accross to the
report?

Here is the code for the border:

With Me.NameOfTextbox
If.BorderWith = 2 Then
.BorderWith = 0
.BorderColor = 0
Else
.BorderWith = 2
.BorderColor = vbRed
End If
End With
 
Top