Problem with checkboxes after Service Pack 3

[Gardner]

I am current experiencing problems with the checkboxes on my forms. If
unchecked, clicking will set the checkbox. If already checked, clicking will
have no effect. Setting a checkbox that is already checked to false still
shows true (via vba).

The forms are bound to a SQL Server back end database. Almost all of the
checkboxes have no code attached to them. The remaining checkboxes just tab
to another field after update. I have decompiled and recompiled.

Tabbing to the checkbox and hitting the spacebar works but not clicking with
the mouse. The problems began after Office Service Pack 3 was installed. I
have many versions of the database that were created before the Service Pack
and none of them have working checkboxes now (they worked before the Service
Pack).

An additional problem occurred with a listbox that had 13 columns. The form
would not display, I could not compile. I could not save until I reduced the
number of columns and save the database.

Any help on the checkboxes would be greatly appreciated.

~Gardner

 

[Ken Snell \(MVP\)]

It's a bug that has been introduced by 2003 SP3. MS is aware of it.

 

[Gardner]

Thanks Ken.

Are they also aware of the problem with the listbox as well?

~Gardner

 

[Ken Snell \(MVP\)]

Yes.

 

[Bradley]

It's a bug that has been introduced by 2003 SP3. MS is aware of it.

Ken,

Can you provide a link to a knowledge base article or a bug database
where this bug is documented by Microsoft? Does Microsoft have a plan
to release a patch to fix this, or is there a workaround available
(other than using the space bar)?

Thanks,
Bradley

 

[Ken Snell \(MVP\)]

No link to a KB article has been released yet. I'm told that MS is very
close to publishing a KB article and "fix" for this issue.

 

[A. van Huizen]

Ken, is this the same problem that I see now only 0 and -1 in my
listbox/comboboxes?
The ony strange thing is that I saw this before in SP2, I did something in
the table design and the problem was solved, but now I really don't know
anymore what I did, because nothing helps.

When this is the same bug then I'm 'happy'

Thanks in advance.
Arjan

 

[Ken Snell \(MVP\)]

The bug noted by the other poster is related to using SQL Server as the
backend for the database. I'm not aware that this bug is manifested in the
displays in comboboxes or listboxes. 0 is the actual value of False (or No
or Off) in ACCESS; -1 is the actual value of True (or Yes or On).

You can change the Format property of the combobox to Yes/No, True/False, or
On/Off so that it will show the name instead of the value. This may trigger
a separate bug, related to the use of a Format property for a field that is
in a RowSource query of a combobox or listbox, that SP3 introduced, though.
This separate bug causes a blank display for the combobox or listbox. MS
also is working on that bug.

--

Ken Snell
<MS ACCESS MVP>

 

[A. van Huizen]

Thanks for your fast reply.

Normally I saw in the listbox 'Yes' and 'No', now I see -1 and 0. I didn't
change something and this db works already since 1 year for a client. And I
see it in every front-end on existing databases since this week. So I think
that it is related to SP3 too.

The format of the Yes/No field in the table is set to Yes/No or True/False.
When I change this, it still doesn't matter.
Also when I make the prefered format in the table design empty.

When I make a simple new database with one table, one field and I display
this in a listbox on a form I see only 0 and -1.

It looks like a bug, because I'm not aware that I can change this format
somewhere besides in the table design.

I hope that you can reproduce the same as I see.
Thanks in advance.
Arjan.

 

[KaytrimsKustoms]

Has there been a fix yet for this issue? This service pack was
installed last night via SMS and we can't do our data entry now.

Michael

 

[Ken Snell \(MVP\)]

No link to a KB article has been released yet. I'm told that MS is very
close to publishing a KB article and "fix" for this issue.

 

[David]

Hi Ken,
Any idea yet when the fix will be available? We either have to roll back to
SP2 (not easy) or sit on piles of reports awaiting data entry (not
productive). Any suggestions on how to let MS know this is a huge problem for
us? Your help is greatly appreciated.
David

 

[Ken Snell \(MVP\)]

I wish I had some news for you, but nothing has been announced by MS yet. I
would have thought it would have occurred by now, so something else must be
holding up the process. I'll ping MS and see.

 

[Dave]

Hi Ken,

Any updates? I'm having the same issues as are the rest in this post. My
user's patience levels are reaching critical mass. Hoping there is some news.

Thanks,

Dave

 

[Ken Snell \(MVP\)]

My last communication with MS is that the publication of information is in
the "queue of work", but no date for release has been set.

 

[Ken Snell \(MVP\)]

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674

 

[KaytrimsKustoms]

Thanks for the update Ken.

Michael

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674