[AccessD] Right Justify in List Box

Max (MGA) max.wanadoo at gmail.com
Tue Feb 16 11:46:44 CST 2010


Thanks Charlotte.

I have tried Courier - awful. Courier New - awful.

Any suggestions?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 16 February 2010 16:42
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Right Justify in List Box

Oh, the memories this exercise brings back! Start with a fixed width font.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Tuesday, February 16, 2010 8:13 AM
To: 'Access Developers discussion and problem solving'
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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list