YesNo Datatypes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Bernard said:
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?
Click to expand...

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.
 
Thanks Rick,

BangOn Answer :-)


Rick Brandt said:
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.
Click to expand...
 
Back
Top