Images as a field???

[Ryan, KC8PMX]

I am working on a database for a college security department and want to use
a scanned (JPG etc.) image of the picture on the student's ID as a field
reference. Any tips on this one??

Thanks,

Ryan

 

[Guest]

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. You bind the text
field in your table to your form by setting the Picture
property of the Image control to the field name.