YesNo Datatypes

[Bernard Piette]

Hi,

I'm using the YesNo datatype for many of my fields related to tasks ertc.
Did employee open the door Yes/No is the employee available on weekeedns
yes/no etc.etc.
I've read that access does not print this correctly and I will see only 1's
or 0's for where the field data will go in a report. If that's the case I'm
sure many of you have faced this situation and have workarounds like "Don't
use Yes/No fields instead....

Instead what should I do?

Thanks

Bernard Piette

 

[Rick Brandt]

Hi,

I'm using the YesNo datatype for many of my fields related to tasks
ertc. Did employee open the door Yes/No is the employee available on
weekeedns yes/no etc.etc.
I've read that access does not print this correctly and I will see
only 1's or 0's for where the field data will go in a report. If
that's the case I'm sure many of you have faced this situation and
have workarounds like "Don't use Yes/No fields instead....

Instead what should I do?

Controls on reports bound to Yes/No fields can be CheckBoxes or TextBoxes and
when using TextBoxes the format property can be used to display "Yes/No",
"True/False", "Up/Down", or just about anything else you want.

 

[Bernard Piette]

Thanks Rick,

BangOn Answer

Controls on reports bound to Yes/No fields can be CheckBoxes or TextBoxes and
when using TextBoxes the format property can be used to display "Yes/No",
"True/False", "Up/Down", or just about anything else you want.