union query & yes/no field

S

Susan

How do I get a yes/no field to display as yes/no, not -1/0
in a Union query. Field is already defined as a text box
for yes/no test. Thanks! :)
 
J

John Vinson

How do I get a yes/no field to display as yes/no, not -1/0
in a Union query. Field is already defined as a text box
for yes/no test. Thanks! :)
Click to expand...

Display the Query in a Form (for onscreen) or a Report (for printing),
and bind the field to a textbox with the appropriate format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Newbie Help - IF Yes No Function 0
How to display multiple IIf results in one column 0
Format Yes/No in Union 4
UNION, WHERE or Something else? 3
Union query 5
Union Query and Field Alias 7
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0

Top