mardi 31 octobre 2023

How to change "-1" and "0" in checkbox field filter dialog in Spreadsheet View when it's based on a calculated field (MS Access)?

In my MS Access table I have a Calculated field that returns True or False. Then I use it in my form in Spreadsheet View as a Checkbox. The filter dialog for this field shows "-1" and "0" as filtering options. It's not friendly for the user. How to change it?

Checkbox filter dialog for a Calculated field in Spreadsheet View

I tried to use a calculated field right in the Spreadsheet Form, but filtering of Calculated Fields is not supported in Spreadsheet Forms.

Thank you for your support.




Aucun commentaire:

Enregistrer un commentaire