Checkbox bound to bit field 
Author Message
 Checkbox bound to bit field

I'm building an Access 2002 adp (SQL Server 2000 backend).  I have a
checkbox on a form bound to a bit field.  Whenever I try to update that
field by checking/unchecking the box, Access crashes.
So, I then unbound the checkbox and tried manually setting the field value
by doing me![chkMyBox] = <either 0 or 1, depending on the value of the
checkbox> in the AfterUpdate event of the checkbox.  This caused the
following error:
Method 'Value' of object '_AccessField' failed

And when I close Access, it crashes.

Any ideas?

Thanks,
Andrew



Sun, 29 May 2005 01:43:52 GMT
 Checkbox bound to bit field

It is a known bug.
I have switched from using a check box to a combo box with allowed
values of "Yes", "No".

Try it, it will work with a combo box.



Quote:
> I'm building an Access 2002 adp (SQL Server 2000 backend).  I have a
> checkbox on a form bound to a bit field.  Whenever I try to update that
> field by checking/unchecking the box, Access crashes.
> So, I then unbound the checkbox and tried manually setting the field value
> by doing me![chkMyBox] = <either 0 or 1, depending on the value of the
> checkbox> in the AfterUpdate event of the checkbox.  This caused the
> following error:
> Method 'Value' of object '_AccessField' failed

> And when I close Access, it crashes.

> Any ideas?

> Thanks,
> Andrew



Sun, 29 May 2005 04:02:43 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Write permission error and bit fields

2. Bit Field Always False in VB

3. Bit field SELECT statement not working

4. 16 bit SQL Driver VS 32 bit SQL Driver

5. Array row field by field

6. Help!! Updating a DB field through FIELDS[x]

7. SQL 7, DTS converting from a char field with a numeric value to a money field

8. ( field + 0 ) to order character ( number ) fields ??

9. Calculated field based on result of a field

10. How to retrive PK fields and Foreign Fields in Oracle DB

11. Array row field by field validation problem


 
Powered by phpBB® Forum Software