Check Box or Option Button and SQL 2005 bit data type

[NickyJay]

Hi,

I am trying to put a check box or option button onto a form that is bound to a bit data type in a 2005 sql database. However, it won't let me then tick/untick the box or option button.

Microsoft KB acknowledge this bug (I think) and have a hotfix for sp3, which I have installed and it still doesn't work ;0(

Has anybody come across this and have a resolution?

Thanks.

 

[NickyJay]

oh oh...... maybe it's not just the tick boxes. NONE of the controls on my sub-form will accept amendments?!?!

The sub-forms had the correct linkages and everything (controls/form) was set to allow edits/deletions/addtions etc. etc. etc.

The issue was with the table in the first place - the table wouldn't accept a change so just deleted and re-linked the table and it worked!

Just in case anyone else having similar issues.

Thanks.