Yes/No export appearance

[HopyMSU]

Access 2007 question and probably a simple one at that.

I work with a database that I export to excel on a daily basis. We use
a number of "Yes/No" check boxes on our main table. When I export this
table, these checkbox fields appear as "True" or "False." Is there a
way to change this so when it exports it shows as "Yes" or "No" ?

FYI: In the fields' properties, under general, it says "Yes/No"
instead of "True/False" or "Off/On."

Thanks,
A

 

[Ken Snell \(MVP\)]

Use a calculated field in place of the real field in the query that you
export, and use the Format function in the expression for that calculated
field:

SELECT Field1, Field2, Field3,
Format([FieldName], "Yes/No") AS NewFieldName,
Field5, Field6
FROM TableName;