left () function does not work in conditional formatting in Access runtime 2016

Jakub Jagiela 1 Reputation point

left () function does not work in conditional formatting in access runtime 2016
When I use it in conditional formatting, it works only in the full Access version, it doesn't work in Runtime, both 32 bit and 64 bit
what is the cause and how to solve it?


Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,996 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,526 Reputation points

    @Jakub Jagiela
    Do you mean if you use Access Runtime 2016 open a database with conditional formatting rules which use Left function, the conditional formatting rules do not work?

    I made a database on Access 2016 and open it via Access Runtime 2016, this issue could not be reproduced as following screenshot shown. The right one is Access 2016, the left one is Access Runtime 2016.


    I would suggest you test on a English machine, which use English as the primary language for both Windows, Office Apps (Access).

    Any misunderstanding, please let me know.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.