union query & yes/no field

  • Thread starter Thread starter Susan
  • Start date Start date
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! :)
 
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.
 
Back
Top