Associate
- Joined
- 25 Feb 2016
- Posts
- 217
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?
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?
Last edited: