I'm not certain why or if the requirement is to actually display the form itself along with its data, but if this is the case, a screen print of the open form saved as a *.jpg file and then placed on a report page inside an image control will allow the form to show up on the report along with its data. I've done this with various state mandated forms and it worked well. I used label or textbox controls for the fields to be filled in and populated the labels with the appropriate values. I added code to hide or display some fields. I did it this way to allow for some mutually exclusive fields to be displayed depending on the data (e.g. separate fields for true or false).
All this wonderfulness was a pain in the database to develop but once done, it exactly replicated the state forms.
As Duane said, I, too, have never printed actual forms but with this procedure, it can be done.
Jeff
----- Original Message -----
From: "Duane Hookom" <duanehookom@hotmail.com>
To: "ms access professionals" <ms_access_professionals@yahoogroups.com>
Sent: Tuesday, August 27, 2013 11:32:49 PM
Subject: RE: [MS_AccessPros] Print A Form
I never print forms. Consider creating a similar report and opening it with a where condition.
Duane Hookom MVP
MS Access
> To: MS_Access_Professionals@yahoogroups.com
> From: anandgb@optonline.net
> Date: Wed, 28 Aug 2013 02:17:41 +0000
> Subject: [MS_AccessPros] Print A Form
>
> I tried using the print function to print an open form. It prints the whole table that the form is attached to.
>
> How can I just print the current form (record) only.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar