Max Wanadoo
max.wanadoo at gmail.com
Tue Feb 16 12:01:43 CST 2010
Getting there but not great due to size. Thanks Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: 16 February 2010 17:57 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Right Justify in List Box Try Consolas - it's designed for an IDE code window. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max (MGA) Sent: Tuesday, February 16, 2010 11:47 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Right Justify in List Box 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 -- 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