Help with text allignement in a list bix control.

[Stacey Howard]

I'm working with Access xp. I have a list box controls that displays
monetary values. The value is of currency data type. I would to have the
values aligned to the right. Can not find any property in which to do this,
any ideas?
ex:
$100.00
$20 .00
$1.00

Stacey

 

[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.

 

[Damon Heron]

Depending on what you are doing with the values, you might want to consider
a subform with the currency list. It will be properly aligned and you can
make it look like a list box. A double-click event could be used to select
the currency value you need. As in:

Private Sub PurchasePrice_DblClick(Cancel As Integer)
Forms![Form3]!Text4 = PurchasePrice.Value
End Sub

which assigns the selected currency to a textbox.

HTH
Damon