This might be something for the Forms discussion board. But it also involves VBA coding.
I have 3 bound text boxes which I have placed in the footer section of a form. The footer section is invisible to the form user.
The user enters data into 3 unbound text boxes which are visible and then clicks on a SAVE command button to save the record.
The VBA code for the command button transfers the entries from the unbound text boxes into the invisible text boxes and saves the record.
My problem is that the VBA code keeps changing the name of one of the bound text boxes after I enter the code.
I usually put the prefix "txt" in front of Text Box names. In this case, I used the following names:
txtepisodeID
txtfunctionID
txtnameID
When I key in the VBA coding and hit enter, ACCESS capitalizes the first "E" in the text name as follows: txtEpisodeID
So I decided to rename all the Text Box names to:
txtEpisodeID
txtFunctionID
txtNameID
for the sake of consistency.
Oddy enough, the VBA coding does not allow the "F" and the "N" to be capitalized.
The coding seems to work fine, but this capitalization in some cases, but not other cases is very odd.
Does anyone have any idea why this is happening?
I have 3 bound text boxes which I have placed in the footer section of a form. The footer section is invisible to the form user.
The user enters data into 3 unbound text boxes which are visible and then clicks on a SAVE command button to save the record.
The VBA code for the command button transfers the entries from the unbound text boxes into the invisible text boxes and saves the record.
My problem is that the VBA code keeps changing the name of one of the bound text boxes after I enter the code.
I usually put the prefix "txt" in front of Text Box names. In this case, I used the following names:
txtepisodeID
txtfunctionID
txtnameID
When I key in the VBA coding and hit enter, ACCESS capitalizes the first "E" in the text name as follows: txtEpisodeID
So I decided to rename all the Text Box names to:
txtEpisodeID
txtFunctionID
txtNameID
for the sake of consistency.
Oddy enough, the VBA coding does not allow the "F" and the "N" to be capitalized.
The coding seems to work fine, but this capitalization in some cases, but not other cases is very odd.
Does anyone have any idea why this is happening?