>I am coding the following to print within VB 5.0 :
>
>Printer.Print Format(datPrimaryRS.Recordset.Fields("SubTotal"), "$##,##0.00")
>
>How can I right justify the amounts when printing. Presently they are left justified.
It can be hard to right justify text depending on the font you use because some characters take less space than others.
But you can always try this:
right( space(10) & Format(1.23, "$##,##0.00"),10)
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com