Yes/No Format where Table Data Shows '1' or '2'

[tkepongo]

Hi there,

A linked table is showing a field with either a '1' or a '2' for Yes/No. In my report, I set the format to Yes/No. When I run the report, all the records displays a 'Yes' regardless if the data is a '1' or a '2'. Does anyone have a quick solution to properly format it to display a Yeswhen it is '1' or a No when it is '2'?

 

[MarkK]

Yeah, subtract 2 from the value of the field. In VBA True = -1 and False = 0.
Cheers,

 

[tkepongo]

Yeah, subtract 2 from the value of the field. In VBA True = -1 and False = 0.
Cheers,

So how do I subtract 2 from the field? Subtract it in the table or by some kind of Event Procedure?

 

[MarkK]

Edit the ControlSource property of the display control to something like ...

=[YourYesNoFieldName] - 2

...or you can amend the query on which the report is based to do that math so one of the columns in the query design grid looks like...

FieldName: TableName.FieldName - 2

Does that make sense?
Mark

 

[tkepongo]

Yes and it works now. Thanks!