Print Form

[mithani]

Hi all,

I have one estimating screen where I enter all my data. I don't want to make any report, just the form screen need to be printed out. So what I do when I finish my data, I pressed Print Screen key and go to paint brush and copy and take print out.

Is there any way to take print out my form screen directly from Access?

thanks for your help

mithani

 

[boblarson]

If you add a button and use the wizard and select FORM OPERATIONS you can have it create one for you and you would get this:

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click


    DoCmd.PrintOut

Exit_Command0_Click:
    Exit Sub

Err_Command0_Click:
    MsgBox Err.Description
    Resume Exit_Command0_Click
    
End Sub

 

[mithani]

Bob, thats wonderful.

Thanks a lot

Mithani

 

[mithani]

Bob,

While printing form, can i shrink my form? Because I can't print form in one page and no way to reduce the form width or height through design. There are many many information there.

Thanks

Mithani

 

[boblarson]

Bob,

While printing form, can i shrink my form? Because I can't print form in one page and no way to reduce the form width or height through design. There are many many information there.

Thanks

Mithani

For that I think you may need to bring up the print dialog so the user can set the %.

DoCmd.RunCommand acCmdPrint

 

[mithani]

Thanks Bob,

I used % but not printing in one page. Even I reduced upto 25% minimum but still I can print only an few line in one page. What could be reason?

Thanks a lot

mithani

 

[boblarson]

Well, it could be that forms are not designed for printing. Reports are designed for printing, so you have more control over that. I can't give you much more than that - I know you didn't want to hear that one.

 

[mithani]

Thanks Bob,

mithani