I have a fabricated recordset and I'm having problem formatting the correct figures. I have defined my fields like
.Append "Debit Credit", adChar, 6
.Append "Currency", adChar, 3
.Append "Amount", adCurrency
rsAgentPostings("Debit Credit") = "Credit"
rsAgentPostings("Currency") = "GBP"
rsAgentPostings("Amount") = Format("1507.5000000", "###,###,##0.00")
Even though I have specified the formatting when I check the value in rsAgentPostings("Amount") its 1507.5 instead of 1,507.50.
I changed the datatype to adChar and the length to 50 and it formats correctly, but in the grid we use (UltraGrid) its left justified when i force it to right justify the value disapears - bah. So I have changed the datatype back too adCurrency.
So my question is why isnt the field formating correctly? ie 1507.5 instead of 1,507.50
Thanks in advance