SQL 'Bit' data type to return yes/no in Access

[skyline666]

Hi,

I want to be able to input yes or no in a field called ScheduleImpact in a table called Risk in Access. Now this sounds simple, but I am using SQL Server 2005 as a back end and Access 2003 as a front end (used as a project, not an application, so that it is on the same server as the database in SQL). In SQL I have the data type bit (to give 1 or 0). When I type in 1, or true, or yes in Access it gives me the value true. What I want to be able to do is change this true to a yes (or false to a no). I also want to be able to do this by still using the bit data type in SQL. Can this be done?

Many thanks in advance.

Andrew

 

[PWise]

if this is on a form change the text box form to yes/no

 

[skyline666]

hi,

I cant do this as the versions of Access and SQL are different, and don't allow changes, so cant change in Access. My tables were originally linked together through the primary keys (to the same field in other tables), but I have since removed this, and now in the form, I get tick boxes instead of being able to enter 1 or true.

I dont think there is a way to do what I want, but if there is, please let me know!!

Many thanks,

Andrew

 

[skyline666]

sorted now, ive made a combo box for the fields n set them to Yes/No