BIT value not changing on Check Box

MonkeyMan666 · March 20th, 2009, 08:11 AM

Hiya,

I have an Access Project file in 2003 format which is linking to a SQL Server 2005 database. In one of the tables there are fields with BIT datatypes with a default value of 0. On the form I am using check boxes for these fields but they arent updating.

I can change the value from false to true but not the other way round, it seems to be stuck on true.

There is no code being fired after the update and I am getting no warnings saying the recordset is not updateable.

Does anyone have any ideas what may be causing the problem?

Thanks in advance

gbianchi · March 20th, 2009, 08:14 AM

Hello, can you debug your code?? I don't remember access specific, but some VB version use 0 and -1 for boolean values (and -1 is not valid in a BIT field). Maybe you are sending the wrong data to it?

MonkeyMan666 · March 20th, 2009, 08:50 AM

There is no VBA code specific to the controls I am setting the data source through the object properties.

Never thought of that, I knew Access had a silly way of dealing with boolean values. I shall try setting the value programmatically and see if that works, I shall let you know how I get on,

Thanks

MonkeyMan666 · March 20th, 2009, 09:25 AM

Yes that works a treat.

Thank you :)

gbianchi · March 20th, 2009, 09:27 AM

no prob. :)

MonkeyMan666 · March 23rd, 2009, 06:19 AM

Hiya,

On second thoughts it doesnt seem to be working. I can change the checkbox but when I want to update the value through code it doesnt seem to work. My code is as follows:

Code:

If Forms!frmInfoChange.chkStaff = True Then
        Forms!frmInfoChange!Staff = 1
    Else
        Forms!frmInfoChange!Staff = 0
    End If

I have also read this somewhere that this could be a problem with Office SP3, has anyone had similar problems?

Thanks

MonkeyMan666 · March 23rd, 2009, 06:32 AM

This is a known problem and more details can be found at:
http://support.microsoft.com/default...=rss&spid=2509

I have installed the patch and it now works fine.