Access 2013 checkbox bug?

[IronSasquatch]

I've been working on upgrading some users' computers over the last couple weeks and someone just brought a strange bug to my attention. In a continuous form that is bound to a table, there is a checkbox that displays whether a shipment was shipped late or not. In all previous versions of Access we're using here, those values are displayed correctly. However, the users who have Access 2013 aren't getting the right data. The entire column of checkboxes is displayed as true, even though most of them should be false. Also, if those users drill down into the details form, the correct value is displayed on that form. I was wondering if this is a known bug or anything in 2013 or if there is another logical explanation for this. Thanks in advance.

 

[spikepl]

How do you know it is a bug? Did you check the values? The values may be displaying correctly, so something causes them to have the values that they show.

 

[IronSasquatch]

Yeah, as I said, the checkbox is bound to the value in the table, and the correct value is displayed if I drill down farther into a single form view that displays all the data for a single record. From the continuous form however, it displays all the checkboxes as true. This ONLY happens in Access 2013. The correct values are displayed in 2010 and 2003.

 

[spikepl]

So you did not check the values in the form where you are unhappy then - I'd recommend you do that first.

 

[IronSasquatch]

Sorry for the delay, I've been swamped with stuff at work recently. I'm one of two IT guys where I work and the other one is out of town for the week. Anyway, the values in the checkboxes vary, but are always in the negative several thousand range (in Acc 2003, 2010, and 2013). The values of the boxes that should be checked are always 255 greater than the values of the ones that shouldn't be. The checkboxes display correctly in 2003 and 2010, but still only display as checked, regardless of value, in 2013.

 

[gemma-the-husky]

almost certainly, if changing one causes the others to change, then the check box is not bound (correctly).

I don't understand the observations you are making about the values.

a true checkbox bound to a yes/no single byte field can only take two values - True and False
-1 is true,
anything else (but correctly or pedantically, 0), is false

 

[IronSasquatch]

Yes, I realize that they shouldn't be able to hold anything but -1 and 0, and in the tables, those are the only values present. However, examining their values on the continuous form gives values in the negative thousands.

Also, I'm not changing any values myself when examining them, because it is sensitive information that Shipping needs. I'm only observing that the value that I'm getting from the control seems to be different each time I open the form, hence why I said it varies. Sorry for the confusion.

 

[gemma-the-husky]

then I do not understand what you are seeing in your form ....

a checkbox is a little square marker that contains either a blank or a tick ....


I assume you have a text box, and not a check box, but in any event, can you post the control source of the relevant check box, please? maybe you are displaying the numeric value of the date.

 

[IronSasquatch]

Yep, I'm aware of what a checkbox is...I'm getting the value programatically by debug.printing it. The control source for the checkbox is a field called 'ORLate', which is a byte field in the table, and in the table itself, displays only -1's and 0's.