Smokeeater
Registered User.
- Local time
- Today, 13:04
- Joined
- Jan 15, 2009
- Messages
- 58
Previously had Access 2010, now on 2016. I have a database that has several fields that start with "5S3D....", not only in the tables but on 2 forms, several queries, and reports. All of sudden everything came to a screeching halt, all pointing towards these fields.
Coding is used to unhide fields based on whether another field on the input form is null or not, and all worked fine until my 2016 upgrade. Now I am getting errors all pointing towards these fields. If I try to compile the code in the VBA window, and I get a "Compile Error: Expected: =" message. Pressing the help button provides no direct reason why the field information now does not work. Here is how the code now looks.
Me!5S3D_Proper_Layout2.Visible = True
Just for the fun of it I removed the Me! on one line of code, and it will automatically put a space between the "5" and the "S", which cannot be removed.
I prefer to not have to change the names of the fields (28 in all) in the tables, queries, reports, and all of the different locations in code, if at all possible.
Thanks.
Coding is used to unhide fields based on whether another field on the input form is null or not, and all worked fine until my 2016 upgrade. Now I am getting errors all pointing towards these fields. If I try to compile the code in the VBA window, and I get a "Compile Error: Expected: =" message. Pressing the help button provides no direct reason why the field information now does not work. Here is how the code now looks.
Me!5S3D_Proper_Layout2.Visible = True
Just for the fun of it I removed the Me! on one line of code, and it will automatically put a space between the "5" and the "S", which cannot be removed.
I prefer to not have to change the names of the fields (28 in all) in the tables, queries, reports, and all of the different locations in code, if at all possible.
Thanks.