can I create a report with ms acces

[simanot]

can I create a report with ms access to print pre-printed form.I just want to print the data only. I know I can do that by check data only on page setup dilog box.
but I want to Know can I do it by write code in then report or the form to print the data only on my pre-printed form.

 

[jmeadows7]

Yes, you can. You need to create a query or other way to generate the data to go on the report. Then instead of generating a report from a report wizard, just go into design view, set the source for the report to be your query, start dropping text boxes on the report, delete the labels.

Then, set the source of each text box to be the piece of data you need, arrange so it fits on your pre-printed form correctly, and voila data on a pre-printed form. We've used this to pring 1099's the past few years.

I'm marking this for e-mail notification if you need some additional help.

Jimmy