
greenhorn question abt variable -- currency -- 2 decimal--right align into pictuebox
>all financial data is supposed to be put into one column with right
>alignment and dollar signs, etc. okay so far, but some of my
>manipulated data prints as ($8.5 instead of $8.50).
>if i use the format$ "currency" then i lose the right alignment
>places. how is this handled? your help appreciated.
>catherine
Paste this in a new form as see if it fits your needs....
Sub Form_Load ()
Dim x As Currency
Dim t As String * 12 'Note this is fixed length
Show
FontName = "Fixedsys"
FontBold = False
For x = -1000 To 1000 Step 91.15
RSet t = Format(x, "$#,###,##0.00 ;($#,###,##0.00)")
Print t
Next x
End Sub