using ckeck box in tables

[Roy Goldhammer]

Hello there

I have application on access 2003 adp.

To some subForm i have i bound access table in order to make it the
dinamicly way to work.

The table is sql server 2005.

in the table there are bit values. I would like to present them in my table
as checkboxes and not as yes/no or true/false.

Is there a way to so so automaticly?

 

[Norman Yuan]

"I would like to present them in my table"? Do you mean a table on one of
your ADP application's Forms, or you mean the actual table of the database?

If it is former, you can do it when design your form. If is latter, then you
cannot: table in database is for storing data (in this case, it is a BIT),
not for displaying data.

 

[Roy Goldhammer]

Whell Nornam

I ment the table.

on mdb i could set the way how yes/no values will present:checkbox, yes/no,
True/fales. Is there a way to set it also on adp?

 

[Norman Yuan]

Well, you cannot, and more importantly, you should not care how a bit column
in a table is presented (as check box, yes/no...) when you use whatever tool
to look the SQL Server database table. If you look at the table as db
admin/developper, you know what 0/1 means, while the user of your ADP app
shoud NEVER directly work, or even look at the database table. He should
only deal with the data in table through the forms, reports, or maybe views
you desined in the app.

So, the straight answer is no, in ADP, you do not have the option for that.