show more than 2 decimals in list (1 Viewer)

[AccessKurzo]

I have a list bound to a query - one of the fields is a currency field.
In the query, I can show more than 2 decimals in the result, but when used in the list, it rounds off the result to 2 decimal places.

What can I check?

thanks

 

[jjturner]

I haven't experimented with currency in a list box, but I have experimented with getting numbers to right-align in a list box. You would use a function to programmatically fill it - that way you have control over how to format each value that gets loaded into it.

Check the Access help files on programmatically filling the lb.

HTH,
John

 

[Pat Hartman]

Before resorting to code, I would try a Format() function in the listbox's rowsource query.