Change Yes/No field to display text value

[GWINTO]

I am writing a query in Access that is required to export to excel, one of the fields is presently a yes/no field but needs to be exported as a text value (dependant on the condition).

I have tried: IIf([YesNoField]=True,"Text1","Text2&quot'

This doesn't work, when the query is run I am presented with a field of greyed out checkboxes.

 

[gojohnnygogogogo]

how about:
IIf([YesNoField]=1,"Text1","Text2&quot

 

[GWINTO]

Should have said, I've tried this and it gives the same result

 

[GHolden]

Try..

IIf([YesNoField],"True Text","False Text&quot


There are two ways to write error-free programs; only the third one works.

 

[CosmoKramer]

GWINTO,

Your original statement will work in your query, but you have to use it in an expression field, not with the bound Yes/No field. Something like this:

txtYesNo: IIf([YesNoField]=True,"Text1","Text2")

 

[GWINTO]

The problem turned out to be the name I had given the expression field, still havn't figured out why, but after changing it my original syntax worked - thanks guys