Format Yes/No in Union

[CJ]

Hi Groupies

I have a union query that combines 2 yes/no fields. When I run the query, I
get -1 and 0 instead of Yes and No.
How can I force the formatting to Yes and No?

 

[John W. Vinson]

Hi Groupies

I have a union query that combines 2 yes/no fields. When I run the query, I
get -1 and 0 instead of Yes and No.
How can I force the formatting to Yes and No?

By displaying the results of the Union query on a Form or Report, with the
formatting of the textbox set appropriately.

Query datasheets are of *very* limited utility and should not be used for data
presentation.

John W. Vinson [MVP]

 

[CJ]

By displaying the results of the Union query on a Form or Report, with the
formatting of the textbox set appropriately.

Query datasheets are of *very* limited utility and should not be used for
data
presentation.

John W. Vinson [MVP]

Hi John

I have the results showing up in a combo box and I was hoping to have that
column read yes/no instead of -1/0. Is there no way to change it for the
combo? I do have an alternative but this would be my preferred method.

 

[John W. Vinson]

I have the results showing up in a combo box and I was hoping to have that
column read yes/no instead of -1/0. Is there no way to change it for the
combo? I do have an alternative but this would be my preferred method.

One thing you could try is to set the Format property of the query field to
Yes/No. Or, you could use a calculated field in the query:

ShowYesNo: IIf([yesnofield], "Yes", "No")

and display that in the combo rather than the raw yes/no field.

John W. Vinson [MVP]

 

[CJ]

I have the results showing up in a combo box and I was hoping to have that
column read yes/no instead of -1/0. Is there no way to change it for the
combo? I do have an alternative but this would be my preferred method.

One thing you could try is to set the Format property of the query field
to
Yes/No. Or, you could use a calculated field in the query:

ShowYesNo: IIf([yesnofield], "Yes", "No")

and display that in the combo rather than the raw yes/no field.

John W. Vinson [MVP]

Setting the Format Property does not work, thus my posting.
I will give the calculation a try otherwise I will use my alternative.

Thanks John!