ACC: Invalid Reference to Field '<value>' Using SetValue Macro
ID: Q96580
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
If the Expression argument of a SetValue macro action evaluates to a text
expression that begins with a letter, you may receive the following error
message when a SetValue macro action tries to set the value of a
control.
In Microsoft Access 7.0 and 97:
! The object doesn't contain the OLE Automation object '<value>'
In Microsoft Access 1.x and 2.0:
! Invalid reference to field '<value>'
CAUSE
An Expression argument of a SetValue macro action that begins with a
leading equal sign (=) is understood to be a field name.
RESOLUTION
Remove the leading equal sign in the Expression argument.
MORE INFORMATION
Steps to Reproduce Behavior
- Create the following macro and save it as My Macro:
Macro Name Action
---------------------------
My Macro SetValue
My Macro Actions
-------------------------
SetValue
Item: Field0
Expression: ="A023bbb"
- Create a new form not based on any table or query.
- Add a command button to the form by dragging the macro named My
Macro from the Database window to the form.
- Add a text box to the form and set its Name property (or ControlName
property in version 1.x) to Field0.
- Switch the form to Form view.
- Click the command button to run the macro. Note that you receive the
following error message.
In Microsoft Access 7.0 and 97:
! The object doesn't contain the OLE Automation Object 'A023bbb'
In Microsoft Access 1.x and 2.0:
! Invalid reference to field 'A023bbb'
REFERENCES
For more information about the SetValue action, search the Help Index for
"SetValue."
Keywords : kberrmsg kbusage McrArg
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb