[AccessD] Right Justify in List Box

Max

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

William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Tuesday, February 16, 2010 11:12 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: [AccessD] Right Justify in List Box

> Hi,
>
> I am trying to get varying values in a LIST Box and have them right
> justified.
>
> This won't do the trick...
>
> strTotal = Format(Nz(rst!AcBalance, 0), "##,##0.00")
> strTotal = Space(12 - Len(strTotal)) + strTotal
>
> Varying values give varying spacing.
>
> Any suggestions?
>
> Thanks
>
> Max
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>