Access 2003 - After SP3 possible bugs

[Guest]

I just installed Office 2003 SP3 along with other Updates from MS. Since
doing do I have the following problem. In some(not all) dropdown combobox's,
the first column does not show data. After I select a row, the item will
show up when the box is collapsed but not when open. Data in other columns
in visible. I have been trying to find a pattern to figure out why this is
happening to determine a work around. This is not happening in all cbo, just
some.

Has anyone else experienced this.

 

[Ken Snell \(MVP\)]

By chance, the field to which the combo box is bound is a text field and has
a Format property setting for the field in the table? If yes, this is a bug
that has been reported by many ACCESS users during past week. It apparently
is a bug in Office 2003 SP3, which was released by MS about a week ago. MS
is aware of the bug and is working on how to fix it.

In the meantime, the "complete workaround" is to remove the Format
property's value from the field's properties in the table's design view.
Otherwise, concatenating the field's value with an empty string also seems
to "overcome" the problem.

 

[Guest]

Thanks for your reply. That is the problem. I am glad it has been reported
I was going nuts. This may be related as I also have a list box that one of
the columns should read Yes or No. Now it reads -1 or 0. Is this the same
problem?

I really appreciate that you responded to me so fast.

Mark

 

[Ken Snell \(MVP\)]

This bug affects both combo boxes and list boxes, so it's possible that
the -1 (which is the value of Yes or True in ACCESS) or 0 (which is the
value of No or False in ACCESS) display is related to this issue.

 

[Guest]

Perfect! Your solutions has spared us a lot of troubles!
From now on, we'll put all our formatting into forms whenever possible...

Thank you very much.

Albert