[AccessD] Right Justify in List Box

Well, that is great lateral thinking. I wont pull down your example but I
will write my own.

Thanks very much AD for pointing me in this direction.  As you will see from
my previous  posting, I have just found a solution but I am so annoyed with
myself for not thinking of this alternative way to overcome the problem.

I was standing too close to it and forget my own mantra "Go and lie down and
think about it", instead of sitting here trying  to code around it.  There
is nearly always an alternative way to crack a problem once you distance
yourself from it - and that I dismally failed to do.

Thanks for the insight!

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: 17 February 2010 18:26
To: Access Developers discussion and problem solving
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com