True/False checkboxes with ODBC

[Nico__]

Hello everyone,

I am connecting Access to a mysql database with MysqlODBC.

Everything is fine, except the boolean fields.
I do not manage to show a checkbox in the Access table view.

For example, my mysql fields are is BIT (1) or TINYINT (1). All I see
in Access are values 0 or -1. I expected to have boolean checkboxes,
like before with the Access field "True/False".

How can I do to have checkboxes back in my table view ? My users are
really used to them and it is so slow to write "-1" or "0" instead of
just checking a box.

Thank you.

 

[Douglas J. Steele]

True/False in Access has always equated to -1/0.

 

[Nico__]

The point is there is no ODBC field convertion in "True/False" that
appear as checkboxes.

ODBC convertion doesn't let me have checkboxes true/false fields like
in this picture : http://img5.imageshack.us/img5/4370/dataviewtruefalsecheckb.gif


--
Nico

True/False in Access has always equated to -1/0.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)

Hello everyone,

I am connecting Access to a mysql database with MysqlODBC.

Everything is fine, except the boolean fields.
I do not manage to show a checkbox in the Access table view.

For example, my mysql fields are is BIT (1) or TINYINT (1). All I see
in Access are values 0 or -1. I expected to have boolean checkboxes,
like before with the Access field "True/False".

How can I do to have checkboxes back in my table view ? My users are
really used to them and it is so slow to write "-1" or "0" instead of
just checking a box.

Thank you.

 

[Douglas J. Steele]

Reading your question a little closer, you should never be letting your
users work directly with the tables (or even with queries). You should
always be using a form for input.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The point is there is no ODBC field convertion in "True/False" that
appear as checkboxes.

ODBC convertion doesn't let me have checkboxes true/false fields like
in this picture :
http://img5.imageshack.us/img5/4370/dataviewtruefalsecheckb.gif

 

[Nico__]

Reading your question a little closer, you should never be letting your
users work directly with the tables (or even with queries). You should
always be using a form for input.

Thank you Doug, I think I understand better how Access works with your
explanation. Means more work for me now.