Formatting columns in as List Box

[RaptorRaptur]

Is there a way to format columns in a list box containing different forms of data. So a list box contains a few columns with text - align left. But then a column with amounts in it which I would like to right align and present in the format 99,999,999.99

Not that I need it now, but a date field as dd/mm/yyyy as well.

Regards,

Alan

 

[DHookom]

A fixed space font with spaces as padding could work and might be the easiest.

 

[theDBguy]

Maybe another option is to use a subform as a listbox?

 

[June7]

Padding with spaces is only way I know.

 

[RonPaii]

Padding with format and spacing with a fixed width font.

Example query

SELECT
    tblGLPost.Account,
    Right(space(15) & tblGLPost.Debit, 15) As RightJust,
    Format([tblGLPost].[PostDate], "dd/mm/yyyy") AS TheDate
    FROM tblGLPost
    WHERE Format([tblGLPost].[PostDate], "dd/mm/yyyy) < #4 / 9 / 2026#
    AND tblGLPost.Debit > 0;

Combo without fixed width font

 

[RaptorRaptur]

Thanks guys,
I appreciate all the comments and advice. However, I think I will swap over from a list box to a sub form as the dbGuy suggested. Ron's suggestion about using a query as he posted is certainly an option to consider.
thank you,

Alan