Listbox Align

[DS]

I need to Right Align a column in a listbox that has numbers in it.
I'm uisng this expression in a Query as the rowsource.

EQuantity: IIf([SalesDetails].[Quantity]=1," ",[SalesDetails].[Quantity])

How can I accomplish this?
Thanks
DS

 

[Arvin Meyer [MVP]]

Have a look at Stephen Lebans list box demo:

http://www.lebans.com/DownloadFiles/CustomListBoxver3.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[DS]

Have a look at Stephen Lebans list box demo:

http://www.lebans.com/DownloadFiles/CustomListBoxver3.zip

Thanks Arvin.
DS

 

[Stephen Lebans]

Hi Arvin,
I believe the OP should look here instead:
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.

Have a look at Stephen Lebans list box demo:

http://www.lebans.com/DownloadFiles/CustomListBoxver3.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

I need to Right Align a column in a listbox that has numbers in it.
I'm uisng this expression in a Query as the rowsource.

EQuantity: IIf([SalesDetails].[Quantity]=1," ",[SalesDetails].[Quantity])

How can I accomplish this?
Thanks
DS