Pictures in the Database

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

How do I add a different picture into individual records
so when I run reports they print out.

I did an OLE field and inserted a picture but it doesn't
seem to "fit" or "size" itself within the field.

Can someone guide me.

Thanks.

Ty
 
If your version of Access permits it, use the Image
Control instead of an Object Frame control. If your
pictures are all the same dimensions, use a sample picture
to size the frame around it. If your pictures are of
different dimensions, make your frame square and set the
Picture Alignment property to "top left". In this case,
there will be a certain amount of dead space at the bottom
or right depending upon the dimensions of each picture.
Then set the following properties of the Image control:
Picture - "(none)"
SizeMode - Zoom
Picture Type - Embedded
Picture Alignment - [see above]
Picture Tiling - No

Depending upon the coding, the table will have a text
field (not an OLE field) that holds the file name or
complete path to each picture. Check the Northwind sample
database for version 2002, where they have switched to the
Image control in their Employees form.
 
Back
Top