Losing formatting in listbox after Windows update

[PeteJohnston]

I'm currently running several financial applications written in Access 2003 Pro which use listboxes to display information. The code is fairly straight forward with some SQL built on the fly to let the users select on multiple categories and display only those rows which match. The problem I'm having, and this has happened many times now, is after Windows XP has decided it is going to download some updates ;-). Columns which were previously formatted or currency no longer display. A document id in the format yyyy/mm/dd does not display at all and the currency value now shows as 5605.11789 :-(.

Has anyone else seen anything like this? The only solution I've found is to totally re-instal MS Office every time and it's beginning to p1ss me off!

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)

 

[PHV]

Have a look here:

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PeteJohnston]

I'll give it a try and let you know.

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)

 

[PeteJohnston]

It worked, thanks PH.

Unfortunately, now it seems to launch into the VBA code when I do an OpenRecordset in the background to fill the listbox. When I hit F5 it continues and displays the data properly. If I then close and reopen the form again it doesn't drop into VBA. I've no idea why - any thoughts?

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)