Displaying photo on form

  • Thread starter Thread starter ajw
  • Start date Start date
A

ajw

I have a form for employees and would like to display
their photo. I have a field in the table that points to
the photo for each individual. What is the best way to
accomplish this. I am a novice and am not sure whether I
use an image object or an OLE object to try to accomplish
this.
Any help would be appreciated.
TIA
ajw
 
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.
 
I have a form for employees and
would like to display their photo.
I have a field in the table that points
to the photo for each individual.
Click to expand...

You're almost there... Jack gave you a good description of the "external
file" approach. There are sample databases for Access 97 and for Access 2000
and later that you can download from http://accdevel.tripod.com,
illustrating this and two other approaches to handling images in Access.
There's also an article discussing considerations in choosing which method
to use. They are intended to be examples, not "finished applications", but
you are free to use any objects or code as a starting point for your own
work.

Larry Linson
Microsoft Access MVP
 
Back
Top