List box - currency fomat

[Glynn]

One of the columns in my list box is for $ amounts, but they show as a
General number i'e., no $ sign, no commas and no decimal point.
Can a list box column be formatted into Currency format

 

[Jeanette Cunningham]

Hi Glynn,
do the formatting in the query that feeds the listbox.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Glynn]

Thanks Jeanette -worked fine - but now I want to right justify the Currency
column. Some people are just never satisfied!
I noted however a similar question - and the answer is to download a zip
file from www.lebans. I will try that unless you know a simpler way.
Thanks again.

 

[Jeanette Cunningham]

The other way is to use a subform in place of the listbox. You can make it
look the same, it does give more flexibility.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Glynn]

Thanks Jeannette - Yes the subform appears the best solution.
Thanks

 

[Glynn]

Yes the Subform appears to be the best solution.

Thanks Jeanette