Processing
 

Export Access Query to Excel - Check boxes show True/False

27/08/2016 12:52#1

New2This

Member

Joined at: 4 months ago

Post: 1

Thank: 0

Thanked: 0

I'm testing exporting some of my MS Access queries to excel. My check boxes are showing true or false instead of yes or no. Any way to keep it as Yes/No? At this time I'm not using any coding to do it, just the export button. The pivot tables and charts will be updated with new data from the queries as new customer information is entered over time. Any ideas of how to do this are appreciated.

27/08/2016 17:15Top#2

Sergey S.

Member

Joined at: 4 months ago

Post: 1

Thank: 0

Thanked: 0

In query designer select the field with Yes/No data type and then in properties select Yes/No for Format property on General tab and Text Box for Display Control property on Lookup tab

Update

If used DoCmd.TransferSpreadsheet for export to XLS, query field format doesn't matter, transfer procedure takes default format of Yes/No fields and converts into text like "True/False" (depends on language of Office user interface). In order to override default format, conversion from Yes/No to text should be done in query. If you cannot edit existing query, create new one with formulas in Yes/No fields like this:

MyYesNoField: IIf([MyTableOrQuery].[MyYesNoField],"Yes","No") 
Similar articles

Excel More conditions in one formula?

4 months ago - Reply: 2 - Views: 171

Get Workbook reference from Open File dialog

4 months ago - Reply: 2 - Views: 128

Add Calculated Field To Pivot Table

4 months ago - Reply: 0 - Views: 5

Nested IF Functions in Excel not working

4 months ago - Reply: 3 - Views: 163

Formulating Date in Excel 2013

5 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

5 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

5 months ago - Reply: 1 - Views: 19

excel search and copy in/from another file

5 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

5 months ago - Reply: 0 - Views: 4

Excel static conditional formatting area

5 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re