Putting Photo on a form

  • Thread starter Texas ReEntry Services
  • 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?
 
J

John B. Smotherman

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top