Access 365 changing case of field/fieldname

[jake7363]

Hello,



There is probably a simple answer to this that I am overlooking, but I have a strange issue occurring. I have two separate tables in a database for which I am using "DOCNO" as an autonumber, key field in each; however, the tables do have two unique data sets.

In Table 1, I am using Conditional formatting to a) color highlight the current row and b) highlight the current field in that row with a different color. It works perfectly.

In Table 2, I followed the exact same process (for which I wrote down the process to ensure I followed it correctly), checked the settings multiple times (including for any typos) and Access changed the Field from "DOCNO" to "Docno". The expression in the Conditional Formatting refers to a hidden textbox called selDOCNO.
The expression reads:
selDOCNO = DOCNO.

In Form_Current, the same expression exists:
Form_Current
selDOCNO = DOCNO.

The only thing I can think of is the possibility that the same Field Name (not control name) is confusing the issue, being in the same database. Is that illogical? If so, is there another answer?

*Note: I am a slight bit past Novice, please be kind. 8~/)

Cheers

[Welshgasman]

Access is not case sensitive.
No idea as to why, but I would not be too concerned.
Is there a setting in 365 that makes ProperCase for variables/controls?

[CJ_London]

Because access is not case sensitive, sometimes if you change the case of an object name having already referenced to it, it retains the original case. Usually compact/repair or copying everything to a new db will solve the issue.

I would argue that field names should be unique to the application, not just the table. Although DocID is not as meaningless as ID, in the context of your application it would appear it is

[jake7363]

I guess the only option, then, is to delete one of the primary keys and start from scratch.

I am going to leave this post open until I can test out the revised form is finished in case there might be another issue.

Thanks for the input.


Best Regards,
Jake

[jake7363]

Back again. The problem I originally reported was based on an assumption that I made in order to avoid the potential lack of clarity in my explanation of the ultimate problem. Now, I made the change to the second Primary Key and the case is consistent.

The reasoning I had was that the problem of the case-change caused the main issue of the selected row color not displaying. Since I have verified that the Conditional Formatting is correct, are there any suggestions for the selected row not showing the color?

[CJ_London]

You need to use square brackets

[selDOCNO]= [DOCNO]

[Micron]

Access is not case sensitive.

At least not by default?