Printing images form

[StephenD]

Hi People,

I have a form that contains linked JPEG images on it. The size of the images vary so I've made my image frame as large as possible to accomodate this and set the picture size mode to 'Clip'. It appears just fine on the screen. I want to be able to print the image as it appears on the screen-however because I've sized the image frame as large as possible it prints around 8 blank pages along with the image. Is there a way I can get it to print in clip mode like it appears on the screen??

Thanks,

StephenD

 

[Fizzio]

Rather than printing the form, create a report to print out the info you require and set a command button to print it. You will have much more control over formatting the information that way.

 

[StephenD]

Thanks for the reply-
I thought about using a report, but the images that the form loads up are based on the records a user selects via a drop down combo box. I don't know how I could get the same functionality via a report-could I place a report on the form and then link the report to the current form's record?
I can explain in more detail if needed.

Thanks,

StephenD

 

[Fizzio]

Yep, almost there. Create a query with all the things you want to display on the report. In the criteria for the RecordID whatever it is, set it to =Forms!NameofYourForm!NameOfSelectionCombo (providing that the first column is the ID field.) Create a new report based on this query and on the form (by wizard or manually), create a command button (the wizard will help you here) and on the On_Click event of the form use the line

DoCmd.OpenReport "NameOfReport", acViewNormal

HTH