using a checkbox

[johnc83]

Hi all,

I am trying to use a checkbox and I'm sure I'm overcomplicating it. Would appreciate help pls..

My tblCustomers has a field called 'OnStop' which tells the user if he/she is able to sell a product to them when they come to book them in. At the moment I have it as a varchar datatype with either Y for Yes or N for No.

On my Customers form (after the customer has been loaded) I check to see if the value is Y or N. Depending on this, I then set the checkbox to either checked or unchecked.

Is there a way I can give this a proper data type so that when the customer loads, the checked/unchecked state is completed automatically?

Thanks for any help

Regards, John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express

 

[earthandfire]

Bit

Hope this helps

 

[johnc83]

Cheers, i'll try that out

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express