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