Results 1 to 4 of 4
  1. 01-31-2021, 10:25 PM #1
    UT227
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    Format a list box

    Is it possible to format a column in a list box? I have one column that is currency. I'd like it formatted that way. I'm not sure if it's possible.
    Reply With Quote Reply With Quote
  2. 02-01-2021, 01:47 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,543
    Quote Originally Posted by UT227 View Post
    Is it possible to format a column in a list box? I have one column that is currency. I'd like it formatted that way. I'm not sure if it's possible.
    You can format the field in the query that populates the listbox.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 02-01-2021, 07:24 AM #3
    moke123's Avatar
    moke123
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,654
    Quote Originally Posted by UT227 View Post
    Is it possible to format a column in a list box? I have one column that is currency. I'd like it formatted that way. I'm not sure if it's possible.
    If it's currency in table it should be currency in listbox.
    If it isn't you can convert it with CCur().
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks
    Reply With Quote Reply With Quote
  4. 02-01-2021, 08:03 PM #4
    UT227
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    Perfect. Thanks.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Table shows sequential list number instead of list text when referring to a list from a list
    By RustySmith in forum Access
    Replies: 8
    Last Post: 12-13-2017, 10:38 AM
  2. How to output query results formatted so that it prints in more of a bingo format than a list?
    By kjb in forum Access
    Replies: 6
    Last Post: 08-27-2015, 01:06 PM
  3. Number Format for a List in a Report
    By Huddle in forum Reports
    Replies: 1
    Last Post: 05-12-2012, 10:29 AM
  4. How to format a date in list Box
    By ganeshvenkatram in forum Access
    Replies: 1
    Last Post: 07-11-2011, 04:52 AM
  5. Format phone number in an unbound list box
    By kbremner in forum Forms
    Replies: 2
    Last Post: 11-08-2010, 05:11 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums