List Box Right Alignment - is it possible?

[mitja]

Hi,
I am using a sub to create a list in a form. There are a few columns with
numbers and I need them right aligned. Is it possible?
Thanks
Mitja

Code:
Me.ListN.ColumnCount = 6
Me.ListN.ColumnWidths = "0cm;4cm;4cm;4cm;4cm;4cm"
Me.ListN.ColumnHeads = True
Me.ListN.RowSource = "SELECT DISTINCTROW ....

 

[fredg]

Hi,
I am using a sub to create a list in a form. There are a few columns with
numbers and I need them right aligned. Is it possible?
Thanks
Mitja

Code:
Me.ListN.ColumnCount = 6
Me.ListN.ColumnWidths = "0cm;4cm;4cm;4cm;4cm;4cm"
Me.ListN.ColumnHeads = True
Me.ListN.RowSource = "SELECT DISTINCTROW ....

See:
http://www.lebans.com/justicombo.htm

 

[John W. Vinson]

I am using a sub to create a list in a form. There are a few columns with
numbers and I need them right aligned. Is it possible?

A listbox isn't the ideal tool for this purpose - could you consider using a
Continuous subform, with textboxes (which can be right aligned)?

 

[Beetle]

See what Stephen Lebans has at;

http://www.lebans.com/justicombo.htm

You might want to bookmark his page also. He has lots
of Access tricks.