I created a macro to change the formatting of controls in 2 forms on enter and exit. It seemed to be working fine as I went back and forth between design and form view. But, when I closed the forms and tried to open either of them from the database window, I get the following error message.
“The object you referenced in the Visual Basic procidure as an OLE object isn’t an OLE object.” When I click OK, I see the following: “Action Failed
Macro Name Macro1.OnEnter
Condition True
Action Name Set Value
Arguments [Screen].[ActiveControl].[BoarderColor], 8388863
I click Halt, the form opens without the first control having the formatting, but when you tab to the next one, all is OK. You can even go back to the first control and it formats accordingly. Why would this happen from the database window, but not when coming from design view?
I’m open to suggestions for fixing. I’m going to experiement to see if the problem is some controls in the form that are unbound.Thanks.
