Field Name Change Trap?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have had to change the name of a table field. The new name migrates
automatically to queries and reports using the field. The field list for the
report shows the new name. BUT, when I try to write code using Me.NewName,
the drop-down list shows only Me.OldName. Furthermore, the report crashes,
saying is cannot find the data element. In the Immediate Box, BOTH versions
of the name cause the error. Is this a bug? Am I trapped? I am using
Access 2000 (SP3).
 
Additional note: When I create a new report using the same query and jump to
the code window, Me.NewName appears in the dropdown list. So, if nothing
else, I probably can re-create the report, which happens not to be very
complicated. I imagine it will run correctly then.
 
David said:
I have had to change the name of a table field. The new name migrates
automatically to queries and reports using the field. The field list for the
report shows the new name. BUT, when I try to write code using Me.NewName,
the drop-down list shows only Me.OldName. Furthermore, the report crashes,
saying is cannot find the data element. In the Immediate Box, BOTH versions
of the name cause the error. Is this a bug? Am I trapped? I am using
Access 2000 (SP3).
Click to expand...


I think this is the kind of thing you get from the Name
AutoCorrect feature. It is strongly recommended that you
disable this option.

You might try copy/pasting the report to see if that leaves
the garbled residue behind.
 
Back
Top