Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Question Unanswered: Format a column within a list box

    I have a list box whose row source is being set by SQL, and I have three columns with numbers that I would like to format to look like "#,##0.00".

    Is there a way to format specific columns in a listbox? It has five columns, and the ones to format are in 3, 4 and 5.

    For instance:

    listbox.rowsource = "SELECT abc.trader, Sum(abc.daily_sales) FROM abc GROUP BY abc.trader"

    needs formatting on the Sum(abc.daily_sales)

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try

    listbox.rowsource = "SELECT abc.trader, Format(Sum(abc.daily_sales), '#,##0.00') FROM abc GROUP BY abc.trader"
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •