Contents in the list box not shown up

[Guest]

I need to create a list box using a list of values from a query. However, the
values don’t show up. I checked the property and the visible is set to Yes
and the row source is “SELECT DISTINCT [PELog Query1]. [ID] FROM [PELog
Query1];†I recently upgraded to 2003 from 2002. I couldn’t figure out how to
fix it. Any help?

 

[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]

That's wonderful. Thank you so much!