Aligning data in a listbox 3

[NvrSaDi]

I have an Access 2000 list box on a form with 5 fields - 3 string and 2 numeric. Data source is a query combining 2 tables. Default alignment is left. I need to retain left alignment of the string data and right align the numbers.

 

[CautionMP]

AccessDB,
The only way I know to do this:[ol]
[li]Convert all the fields to text ([tt]Format$[/tt] the numbers).[/li]
[li]Pad the text values of all the fields you want right justified with spaces ([tt]Space()[/tt]).[/li]
[li]Change the font on your ListBox to a non-proportional font (like Courier).[/li][/ol]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[NvrSaDi]

To CautionMP
Thanks,
Think I can make that work.

 

[earthandfire]

Also have a look here:

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

Hope this helps.

 

[NvrSaDi]

To EarthandFire.
Thanks.

 

[MajP]

I echo EarthandFire. I have used that code and it is very robust.