I need to print the fields of a report to a receipt printer.
Have little clue on how to proceed.
custom report? then just print it?
Hope someone can help me get this right
You need to manually design a report so that when it is printed to a pre
designed receipt form that all the data falls in the proper place. So far as I
know, there is no easy way. The following is slow and time consuming, but it
will work.
1. Make a new form that you can use as input to a query.
2. Make a new query to returns only the data that matches field values in the
form.
3. Make a new report that gets its data from the query. Place text boxes for
each of the fields that you want on the receipt near the top of the report
detail section.
4. Add a command button to your from to open the report. When the report
opens it will look for its source data - the query. The query will look for
the form (which must still be open) for the required criteria.
5. Print one receipt.
6. Carefully measure the distance difference (horizontally and vertically)
that each field needs to be moved so that it will print in the proper location
on the receipt.
7. Open the report in design mode. Add the measured vertical difference to
the controls' TOP property and the measured horizontal difference to the
controls' LEFT property.
8. Print one receipt.
9. Repeat 6. & 7. as necessary to fine tune control positions.
Chuck
