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