[AccessD] Right Justify in List Box

Max,

    For complete flexibility in formatting, if you are in a position to adopt simulated list box, based upon a form, my sample db named Form_SubformAsListBox might be of interest to you. It is in access 2000 file format and is available at Rogers Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Max (MGA) 
  To: 'Access Developers discussion and problem solving' 
  Sent: Tuesday, February 16, 2010 23:16
  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