Database : MS Access 97
Front End : VB 6
OS           : Windows 98 SE
Printers    : Epson 800, TVSE 255
Requirement : Want to print Database content in DOS Mode printing  as INVOICE Format

                    Name Of the Firm
                           INVOICE
----------------------------------------------------------
Sl No     Description         Qty    Price        Amount
-----------------------------------------------------------
1.          Content from database     xxx      xxx




-----------------------------------------------------------
Total                                                       xxx
-----------------------------------------------------------

Initiative to do this :
1. Opened one Text file  "A.txt " using File i/o Open ..command
2. Write the content of Database in that file.
3. Using a Batch file which contains the code as follows
   Type A.txt > PRN Execute the batch file.

Problem faced :
I am not able to format the number in decimal number format.
I wanted to print as follows            But it comes as follows
       12.25                                             12.25
         1.50                                             1.5
     120.50                                             120.50


Please help me.



____________________________
Nitish S. Prabhu

Check this topic

[Edited by Goran on 12-02-2005 at 01:54 PM GMT]

____________________________
If you find the answer helpful, please mark this topic as solved.

quote:

---

nitishprabhu wrote:
Database : MS Access 97
Front End : VB 6
OS           : Windows 98 SE
Printers    : Epson 800, TVSE 255
Requirement : Want to print Database content in DOS Mode printing  as INVOICE Format

                    Name Of the Firm
                           INVOICE
----------------------------------------------------------
Sl No     Description         Qty    Price        Amount
-----------------------------------------------------------
1.          Content from database     xxx      xxx




-----------------------------------------------------------
Total                                                       xxx
-----------------------------------------------------------

Initiative to do this :
1. Opened one Text file  "A.txt " using File i/o Open ..command
2. Write the content of Database in that file.
3. Using a Batch file which contains the code as follows
   Type A.txt > PRN Execute the batch file.

Problem faced :
I am not able to format the number in decimal number format.
I wanted to print as follows            But it comes as follows
       12.25                                             12.25
         1.50                                             1.5
     120.50                                             120.50


Please help me.

---

try this



do while not .eof
  printer.print tab(10); string; tab(len(string)-30); tab(len(number)-2)
.movenext
loop
printer.enddoc