ACC: Invalid Reference to Field '<value>' Using SetValue Macro (96580)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q96580
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
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.
REFERENCES
For more information about the SetValue action, search the Help Index for
"SetValue."
Modification Type: | Major | Last Reviewed: | 5/28/2003 |
---|
Keywords: | kberrmsg kbprb kbusage KB96580 |
---|
|