none
Issue with form property in expression builder - MS Access 2016 RRS feed

  • Question

    • 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.
    Thursday, February 22, 2018 4:54 AM

All replies

  • Hi,

    Based on your description, I will move your thread to Access for Developer forum:

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Regards,

    Emi


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, February 23, 2018 6:23 AM
  • Hello,

    >>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

    I would suggest you figure out where is the Student defined and then rename the property to make a difference.

    Could you please share a simply database file so we could try to use it to reproduce your issue?

    For sharing file, you could share the file via Cloud Storage, such as One Drive, and then put link address here. Thanks for understanding.

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, February 26, 2018 1:57 AM