Results 1 to 1 of 1
  1. #1
    JimO is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Dec 2015
    Posts
    126

    Format data in a Listbox

    I would like to format the field [winLoss] to show as a 3 place percent. It currently displays as a 2 digit percent and I am not sure just how to go about this.



    Here is the current code.

    Code:
    SELECT ID, Div, Team, W, L, WinLoss, GamesPlayed FROM SportsMLBLeagueQry WHERE Div = "AL East" ORDER BY WinLoss DESC;
    Thanks,
    Jim O

    Figured it out, Format([WinLoss],"0.000%")
    Last edited by JimO; 06-23-2016 at 02:32 PM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Listbox currency format
    By princess12 in forum Access
    Replies: 9
    Last Post: 04-14-2015, 03:49 PM
  2. format in a listbox
    By NISMOJim in forum Forms
    Replies: 1
    Last Post: 02-21-2015, 01:26 AM
  3. Replies: 2
    Last Post: 09-19-2013, 10:22 PM
  4. listbox column head format backcolor
    By masoud_sedighy in forum Programming
    Replies: 3
    Last Post: 07-31-2013, 07:44 PM
  5. checkbox format for listbox
    By cpet in forum Access
    Replies: 3
    Last Post: 09-20-2010, 08:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums