listbox not displaying all columns

[jackmcg]

last night I installed Office 2003 Service Pack 3, which solved a major problem in a one db, and I'm praying it didn't cause the problem I have now in another.

here's the problem:
one listbox control lists degrees (ba, bs, etc.) the other lists majors (agriculture, computer science, etc.)

in the list of degrees, if 'mba' is selected, the click event fires code that changes the rowsource of the majors list. when any other item is selected the majors list displays all majors, including mba data. since installing the service pack, the majors list does not display.

the majors list is 2 columns, with 0";1.75" as column widths, and bound column 0. when the column width is changed to 0.5";1.75", column(0) displays, but column(1) doesn't.

But the list is populated. A text box using the controlsource of =lstbox.column(1) displays the values when the the list is scrolled.

Anybody know of side problems associated with Office SP3 or of any workarounds?

 

[missinglinq]

This is one of a multitude of problems caused by SP3!
The combo/list box goes blank if it's RowSource is a table field that has something in its Format property. This can be something as simple as ">" being used to force uppercase. The short answer, until Micro$oft managesto get eberyjting fixed and issues a patch, is to go into the underlying field(s) and remove all formatting. The more complicated answer is to uninstall Access, then re-install it up to SP2.

 

[jackmcg]

done it again...

Thanks missinglinq... that was exactly the prob.... the field in the underlying table had a format attached... took it out... right on the money!

i owe ya one!

if you see a sign with your name on it by the side of the road at the intersection of I64 and I295 a day or two before Thanksgiving, it will be marking a bottle of scotch or bourbon that I left there on my way to Philly