Access VBA field/variable issue

[hans gruber]

I created a table and associated form in access and started doing some vba coding.

In one of the fields I accidently capitalised an extra letter, for instance::

FirstName
MiddleName
SEcondName

In the table I have fixed SEcondName to SecondName, but no matter what I do, when I type it into the vba editor, it alters it to show as SEcondName.

I have deleted the entry from table, form and VBA and compacted/repaired database and then put it back as SecondName, but for some reason vba editor still capitalises the first 2 letters. It shows in table correctly and add fields in the form but the vba editor just wont let go.

How do I fix this as it's driving me nuts?

EDIT: Ok after much larking about it is now working. That was a productive 30 minutes.

EDIT: Ok I've spotted another one. Darn my clumsy fingers. Anyone know a quick wat to fix it?

 

[hans gruber]

Are you using Option Explicit at the top of the modules? This helps you find errors at runtime.

Not sure I seen this before, but what happens with your intellisence if you start typing the same code on a new line?

I've put option explicit. It had option compare database. I have to say I don't know either means.

 

[hans gruber]

The variable is a field in a table and inserted into a form. I added the extra capital when setting up the table. It is present in 3 tables and used on 3 forms, but these are not linked.

I deleted it from all tables. It is not DIM/declared anywhere in the entire project. I deleted every reference to it in the code yet it still it corrects to the extra capital when I type it. I set a global variable in a module. It's fine until I close and open the database when the variable in the module has been updated to the wrong one.

There must be a reference to it somewhere that I'm need to get rid of change but I can't figure out where. I manged to fix the one above but this one is proving tricky.

 

[hans gruber]

Any update @hans gruber did you get it sussed?

I deleted/renamed it everywhere I could find it, did multiple compact & repair. I then declared it in a module. I thought I had sorted it but it reappered.

Then I did it all again and this time it stuck.

I'll be more careful typing in future.