Putting Photo on a form

  • Thread starter Thread starter Texas ReEntry Services
  • Start date Start date
T

Texas ReEntry Services

I am doing a client tracking db and want to include a phot on the form how
does one go about this?
 
I figure you will probably have lots of images? One for each client? To keep
your database small, use a text field in the client table that contains the
fully qualified path to the image (complete path and filename). On the form,
create both a text field with the control source equal to the field in your
table, and an image box, but do not give the image box a control source. In
the Form_Current function in the VBA code for the form, assuming the image
text field is called ImageFileName, include the following code:

Image.Picture = Me!ImageFileName

The image will change to the one listed in the ImageFileName field for each
record.
 
Back
Top