ms-accesslistboxtext-alignment

Is there a way to right-align a numeric column in a ListBox


We have a standard Access listbox with multiple columns. Is there a way to have integer or currency columns right aligned?


Solution

  • As far as I'm aware, not in the traditional sense, no. I believe there are some third-party products that might be able to do this, but there's no native ColumnAlignment properties for listboxes in any versions I've used (haven't used Access 2007, though, for what it's worth).

    Depending on how you are loading the listbox, you could use a fixed-width font (such as Courier) and left-pad your numbers with the appropriate number of spaces, to emulate right-alignment. It's not ideal, but it may be worth a shot.