Numbers in Listbox

[Devonish]

I have a multicolumn list box where some columns contain numbers. These
are always left justified which makes reading the numbers a little
difficult.

Is there a way in which numbers can the right justified in Listbox
columns?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Fletcher Arnold]

"Devonish" <no*****@nowhere.com> wrote in message
news:40*********************@news.frii.net...

I have a multicolumn list box where some columns contain numbers. These
are always left justified which makes reading the numbers a little
difficult.

Is there a way in which numbers can the right justified in Listbox
columns?

If you want tighter control over the appearance, then you could consider
switching to a subform control. You can make it look pretty much like a
listbox and make it read-only, but get much more flexibility with the
format.
Fletcher

[Devonish]

Thank you for the suggestion but I need to make a multiple selection
from
the listbox for later processing.

By that I mean that I want to be able to select a number of lines from
the
listbox and add appropriate entries to another table. A form does not
appear
to allow me to do this.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Stephen Lebans]

See:
http://www.lebans.com/justicombo.htm
New Ver 2.1 Justification.zip is a database containing functions to
center and right justify data for List and Combo Boxes.

Major changes for Version 2.1 are:
Use standard API's instead of functions exposed in Access EXE.

Handle Multiple Columns

One Function for both Center and Right Alignment

Support for controls on SubForms

Huge increase in function execution speed

Clean code with comments
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Devonish" <no*****@nowhere.com> wrote in message
news:40*********************@news.frii.net...

I have a multicolumn list box where some columns contain numbers. These are always left justified which makes reading the numbers a little
difficult.

Is there a way in which numbers can the right justified in Listbox
columns?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Fletcher Arnold]

"Devonish" <no*****@nowhere.com> wrote in message
news:40*********************@news.frii.net...

Thank you for the suggestion but I need to make a multiple selection
from
the listbox for later processing.

By that I mean that I want to be able to select a number of lines from
the
listbox and add appropriate entries to another table. A form does not
appear
to allow me to do this.

Just as I was typing try http://lebans.com/ I see Stephen has posted
himself. The downside of this is, is that there will be a whole bunch of
code which you will have to either try and understand, or you simply cut,
paste and don't worry.

I do understand the complication you mention, but there might be some life
in the subform idea yet. See if you like Stephen's idea first.

Fletcher