Hi, I'm currently in the throes of automating tasks for a non-profit agency... I'm creating forms for the employees to update whatever database, but I need those forms to also be printable when they've been updated. Printable means the form needs to be a full page (it prints a quarter to half page) and I'm having difficulty reformatting it to be more fluid on paper. I'm using Access 2000. Any suggestions are appreciated. Thank you!

Try making a report the way you want it to look then link the report text boxes with the form text boxes. To do this,right click and go to the properties of the report text box, go to the Data or All tabs, and click the "..." by the control source box. Then hit "=" and click on the proper item you want to link it to in the form folder.

_-------------------------------_

After doing this you then only need a button in the form to generate your report. Click on the Command tab of the button, choose an action, then click the "..." and insert this code:

Public Sub Done_Click()

DoCmd.OpenReport "Report Name", acViewPreview

End Sub


_------------------------------_

Hope that Helps

Mike :D