Boolean Display in Excel
Posted on 2010-09-03
Wondering if in Access itself (on the table level) or query level, can I change the value being displayed in the field to display Yes/No instead of True/False for a boolean?
I'm exporting a query from Access to display in a spreadsheet format in Excel. I have a boolean value that holds True/False but on the Excel I would like to display it as "Yes/No"
Below is the code I'm using to execute the query and create the excel file (there is pre-made excel file with formatting - it creates it dynamically with this line of code):
DoCmd.OutputTo acQuery, "qryAGD", "MicrosoftExcel(*.xls)", "H:\Incident\AGD.xls", True, ""