Bit Field Changes to True

  • Thread starter Thread starter pjscott
  • Start date Start date
P

pjscott

I'm using Sql 2000 and Acces 2003. I have a table with a EmploymentStatus
(nvarchar), ServiceEmp (bit) and Timekeeper (bit) fields.

On a subform the Employment Status is a combo box and both the ServiceEmp
and Timekeeper are check boxes and defaulted to False (0).

My problem is when I select something from the Employment Status both the
ServiceEmp and Timekeeper check boxes check to True.

I have tried setting the default value to 0 in both the table and on the
check boxes. But that didn't work. I've created a new form and that didn't
work.

Anyone have a clue what could be going on?

Thanks,

Paul
 
hi PJ,
I'm using Sql 2000 and Acces 2003. I have a table with a EmploymentStatus
(nvarchar), ServiceEmp (bit) and Timekeeper (bit) fields.
A BIT in SQL Server is "True" when it has the value 1 otherwise "False"
when it is 0.

In Access/VBA "True" is any value not equal to 0, especially -1.

When using Access and SQL Server linked tables, it is always saver to
use a number field (TINYINT, SMALLINT, INTEGER or BIGINT) instead of BIT.
My problem is when I select something from the Employment Status both the
ServiceEmp and Timekeeper check boxes check to True.
Anyone have a clue what could be going on?
Have you assigned both CheckBoxes to the same field?


mfG
--> stefan <--
 
Back
Top