List box - currency fomat

  • Thread starter Thread starter Glynn
  • Start date Start date
G

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
 
Hi Glynn,
do the formatting in the query that feeds the listbox.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
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.
 
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
 
Back
Top