Data type values

[SARSSM]

Hello -
I'm trying to change my data type value for the Yes/No data type. It comes
up on my data sheet as True/False, and I want it to come up as Yes/No.
Anyone know how to do this?

Thank you

 

[fredg]

Hello -
I'm trying to change my data type value for the Yes/No data type. It comes
up on my data sheet as True/False, and I want it to come up as Yes/No.
Anyone know how to do this?

Thank you

In table Design View, set the Format property of the field to Yes/No.
What possible difference could it make? Either way it's real value is
either -1 or 0.

 

[Jeff Boyce]

As Fred points out, the underlying value stored in the table is 0 or (if in
Access) -1.

It sounds like you are trying to use the datasheet view as if it were a
spreadsheet. Access isn't a spreadsheet. There are alternate ways of
displaying the data that might be less confusing to end-users...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hello -
I'm trying to change my data type value for the Yes/No data type. It comes
up on my data sheet as True/False, and I want it to come up as Yes/No.
Anyone know how to do this?

Thank you

Don't confuse data DISPLAY with data STORAGE.

The field is *stored* as -1 for True/Yes/checked, 0 for False/No/unchecked.

The display is controlled by the field's format property; bear in mind that in
a professional application it won't matter how the table format is set, since
the user should never see a table datasheet at all, but rather work with
Forms.