An error occurred while saving the commentJimmB commented
It would be really nice to be able to color code ROWS in DATASHEET or QUERY VIEW based on some field value or calculation, for example open versus closed orders, etc. It could be done simply by generating a hex color value in a calculated field and using that to set the background color for the row. I generally use table or query views, not form views, because I change query setups often and making a form to display them is too tedious for me.
Thank you for the feedback. These requests have been an ongoing discussion with the team, both internally and externally. Especially with our continuously increased focus on establishing a stronger Access-SQL experience, we do plan to have some requests on this work looked further into within the next year. We will keep you posted with specific feature designs in scope as well as timelines. In the interim, you can continue checking our public roadmap for feature updates.
The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!
-Access Product Team