Quality form from MS Access

  • Thread starter Thread starter mb
  • Start date Start date
M

mb

We use copyright paper forms that cannot be modified. Therefore it is not
possible to create a new electronic version. One solution has been to scan a
tif, jpg or gif image of the paper form and use it as a background to an
Access form and put the data fields on top. This works ok but the file size
is large and to reduce it lowers the print quality. Any solutions to this in
Access? It would be so nice to have a pdf form as the background, any way
this can be done?
Second attempt to post.
 
Hello m
After scanning the image use a graphics program such as Paint Shop Pro to size the image to the form. When graphics are displayed in Access they can be Clipped, Stretched or Zoomed

Clipping displays the graphic fittings as much as possible within the space strating at the top left corner. Any excess is 'clipped
Stretching adjusts the size both vertically & horizontally to fit; this can distort the graphic as the aspect ratio (size vert compared to size horiz) may be change
Zoom adjust the size to fit while maintaining the aspect ratio. This, however, can leave areas of the graphic frame empty

Adjusting a jpg, which may already be compressed or partially compressed will certainly lead to a degradation of the image. I have a database in which people's photos are displayed and printed & as part of the documentation I specify the size of the graphic (len x width) for the resolution to maximise the quality of the image displayed

Embedding the graphic will certainly chew up the disk space while linking will use less. There has been a lot written about optimising the use of graphics in Access. Depending on the application, I generally only store the path to the graphic in the database & manually display the graphic; this, however, causes a hit on display time. If I remember correctly there are some articles in the Knowledgebase about it. You may also check some of the MSVP site

HT
Terr
----- mb wrote: ----

We use copyright paper forms that cannot be modified. Therefore it is no
possible to create a new electronic version. One solution has been to scan
tif, jpg or gif image of the paper form and use it as a background to a
Access form and put the data fields on top. This works ok but the file siz
is large and to reduce it lowers the print quality. Any solutions to this i
Access? It would be so nice to have a pdf form as the background, any wa
this can be done
Second attempt to post
 
Why use an image as a form background? There's no need.

Just use a standard Access form to enter the data, and use a report to print
it out. The report can have transparent textbboxes on it, that are placed to
coincide with the placement of data entry points on your paper forms.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Thank you for the response but why can I not find my original question to
the group?

Terry said:
Hello mb
After scanning the image use a graphics program such as Paint Shop Pro to
Click to expand...
size the image to the form. When graphics are displayed in Access they can
be Clipped, Stretched or Zoomed.
Clipping displays the graphic fittings as much as possible within the
Click to expand...
space strating at the top left corner. Any excess is 'clipped'
Stretching adjusts the size both vertically & horizontally to fit; this
Click to expand...
can distort the graphic as the aspect ratio (size vert compared to size
horiz) may be changed
Zoom adjust the size to fit while maintaining the aspect ratio. This,
Click to expand...
however, can leave areas of the graphic frame empty.
Adjusting a jpg, which may already be compressed or partially compressed
Click to expand...
will certainly lead to a degradation of the image. I have a database in
which people's photos are displayed and printed & as part of the
documentation I specify the size of the graphic (len x width) for the
resolution to maximise the quality of the image displayed.
Embedding the graphic will certainly chew up the disk space while linking
Click to expand...
will use less. There has been a lot written about optimising the use of
graphics in Access. Depending on the application, I generally only store the
path to the graphic in the database & manually display the graphic; this,
however, causes a hit on display time. If I remember correctly there are
some articles in the Knowledgebase about it. You may also check some of the
MSVP sites
 
The problem with using reports is that you cannot put a
command button on them. So, if you want to be able to
click a button to print, save, next record, close, etc,
you can only do this with a form.

Therefore forms can be used for data entry as well as
printing.

Do you you know a way to get around this, may I ask?

Regards

Adam
 
Adam,

No, you can't put a command button on a form - nor would you want to.
Remember, forms are for data entry - reports are for printing. That's why
each exists. It's no problem to call a report from a form.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top