[RESOLVED] Access/VBA Editor is changing my var names!!??

[CrazyLuke]

I'm doing some work on a friends Access dB.

I changed a few of his poor table field names and control names (e.g., CREDITOR to txtCreditor). When I reference some of the fields in the VBA Editor, it will not make the change in name stick.

It all runs just fine, and the table is showing the field name correctly as txtCreditor and the form is showing the textbox name correctly as txtCreditor, but its still showing txtCREDITOR in the VB Editor.

When I try to replace the CAPS to make it say txtCreditor, it simply reverts back to txtCREDITOR. Anybody know what's causing this?

[pweegar]

Check anywhere you have declared yur variable. Whatever you name a varible with the Dim statement, that's wht all uses of the variable become. Do a copy of the variable and then paste it into the find dialog box and search thru all objects.