Bob Gajewski
rbgajewski at adelphia.net
Fri Jun 11 09:18:01 CDT 2004
Dear List:
I am having a problem with an A2003 db. Since I have just
upgraded to this version, I am still rather new on the
quirks/changes, so please bear with me.
I have a user-defined function so that each field is
"high-lighted" when it has focus, to assist the user
in following the data input screen.
In my form's CBF (frmJobs), I have the following code:
Option Compare Database
Option Explicit
-------------------------------------------------------
Function cbfGotFocus()
Me.ActiveControl.BackColor = 8454143
End Function
-------------------------------------------------------
Function cbfLostFocus()
If Me.ActiveControl.Name <> "cboAll" Then
Me.ActiveControl.BackColor = vbWhite
End If
End Function
-------------------------------------------------------
In each field's properties, I have:
On Got Focus =[cbfGotFocus]
On Lost Focus =[cbfLostFocus]
This has been working perfectly for my A97 and A2K db's.
Now that I have converted this one db to A2003, I keep
getting the error:
'The expression On Got Focus you entered as the event
property setting doesn't contain the automation object
'cbfGotFocus'.
I have Jet 4.0 SP8 installed. There is no custom security
installed; no db password. The following references are
checked:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library
As always, TIA!
Bob Gajewski