List Box Field Problem

[mike.arndt]

I have added a list box to a form in Access 2003. The fields in the
list box are coming from a querry which has a percent format on it.
When I run the querry the fields show up in the % format. When I run
the form the field shows up in .99999 format. Is there some bug in
2003 that is preventing this from displaying correctly? I have the
same database running in 2000 and it displays correctly.

 

[Ken Snell \(MVP\)]

By chance, is the field to which the listbox is bound is a text field and
has a Format property setting for the field in the table? And by chance did
you recently update your Office 2003 software to SP3? If yes to both
questions, this is a bug that has been reported by many ACCESS users during
past weeks. It apparently is a bug in Office 2003 SP3, which was released by
MS some weeks 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.

 

[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

 

[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