Issue with form property in expression builder - MS Access 2016

[rajkumar]

• We have a form where one of the fields needs an expression.
• When we are building that expression, actual need is to select the column name, but we see that there is a property coming up along with the column name with the same name.
• Even if we select the column name, when we save it, it is automatically being changed to form property which is causing the issue in the result.
• We want an expression like this: =IIf([SNAME]="FC";"FC";[STUDENT])
• But when we save it, it is being changed to: =IIf([SNAME]="FC";"FC";[Student])
• STUDENT is a column name which we want to be in the expression
• Student it is shown as a form property in the suggestions but it is not there in the property sheet, we don't know where it is being defined.
• Please check the below screenshot, where you can observe all the above points mentioned.
• 

[June7]

cross-post https://stackoverflow.com/questions/...ms-access-2016

[isladogs]

Access doesn't always discriminate between upper and mixed or lower case
However it is likely that somewhere you have done something like this

Dim Student As String

Either find the cause of the issue ....
or build the expression manually as you know what output you want already

[davegri]

It looks like Student is the name of a form and STUDENT is the name of a textbox on the form, or a field name in a table.
Suggest you rename the form frmStudent.