We help IT Professionals succeed at work.

Access 2007 list box - display two decimal places when the last digit is 0

taborrg
taborrg asked
on
Hi,

I'm using a list box to display invoices.  The Row Source is:

SELECT
Description,
Amount
FROM T_Invoices;

It works OK, except that it truncates the final 0.  So 300.50 is displayed as 300.5

Is there a way to make it display as 300.50?

Thanks,

Rick
Comment
Watch Question

Most Valuable Expert 2012
Top Expert 2013
Commented:
Select
Description,
Formatnumber(amount, 2)
Etc ..

Author

Commented:
Thanks!
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
You might want to reconsider the listbox, where text is always left justified.

Instead, I would create a continuous subform, which you can make to look alot like a list.  This gives you the flexability of formatting the controls rather than the data and also allows you to right align numeric values.