[AccessD] Right Justify in List Box

Hi Max

That can't be true, you have the same compiler as I do. 
Here's the complete SQL I have tested:

SELECT 
  tblAmount.Amount, 
  Format([Amount],Space(14-2*Len(Int([Amount]))-Abs([Amount]>1000)) & "#,##0.00;" & Space(15-2*Len(Int([Amount]))-Abs([Amount]>1000)) & "-#,##0.00") AS RightAmount
FROM 
  tblAmount
ORDER BY 
  tblAmount.Amount;

But it won't accept Null values. 

/gustav


>>> max.wanadoo at gmail.com 17-02-2010 16:04 >>>
Still getting problems with this function, just wont compile. Gives error on the int bit.
If I break it down, it will run but only give the integer part of the currency.

I have downloaded the  Lebans code but that is so cumbersome because it uses
twips. Surely there must be another way.

Max