List box Format? On some computers

[Directlinq]

Hi i have 3 listbox's on seperate tabs, with multiple columns. None of them show as being currency. But on 1 computer i have, it does show as currency and is perfect. But my other 2 computers just show as numbers. Very strange. But i dont know the differrence between the computers. They are all access 2003 and all windows xp.

Please help

Many Thanks

 

[boblarson]

Check the computer's REGIONAL SETTINGS to see how currency is supposed to be displayed. It is likely that yours and theirs are set slightly different.

 

[Directlinq]

Just checked them both and compared. They seem exactly the same, no differences. You are talking about Control panel regional settings arnt you?

Many Thanks

 

[boblarson]

Just checked them both and compared. They seem exactly the same, no differences. You are talking about Control panel regional settings arnt you?

Many Thanks

Yes, that was what I was talking about. That was the only one I could think of for something like this, unless you might be using a FORMAT function somewhere and there is a references problem. But I think you'd see other issues as well, if that were the case.

 

[Directlinq]

I have sorted it.
If anybody wants to know i was using access 2003 sp3. There is a known bug in sp3 that causes problems like this.

I had to install microsoft hotfix (945674)

This solved my problems.