Percentage not working in list box after upgrade?

[Allan]

Hi

I have A2003 with SP3.

My problem is occurring in two separate databases. Both have forms with a list box receiving data from queries.

The forms list box displays various category totals and the category percentages of the overall total.

That is until after installing SP3 (I think it was about this time that the problem started occurring) the list box will no longer display a percentage figure, a multiple decimal number is displayed.

If I run the source query on its own, it gives me a percentage fiqure (format is set to percentage). No other changes were made to either database before losing the percentage format to a multiple decimal number (which is correct if expressed as a %).

I have also tried to create a new list box based on the same query without success.

I would appreciate any advice please. I could not locate a similar situation in other posts.

 

[missinglinq]

SP3 did a number on comboboxes/listboxes. You say you have it installed but don't mention the hotfix MS issued for it, so first thing I'd do is download and install it. Even if it doesn't fix your problem (and it very well may) it'll correct a bunch of other bugs introduced by this wonderful "upgrade!"

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

 

[Allan]

Thank you "missinglinq".

Works fine now. I need to pay more attention to hot fixes!

Regards