Yes, that's what I'm after displaying the image in the form. Not sure how to go about it though
Morning,
In access, there is an object on the menu that allows you to insert an image. Without stating the obvious, this is an image control. The image control has a property that can be assigned to a control source.
Initially, the easiest thing to do is select the control off the menu. Create one on your form. A wizard will open up allowing you to select your image file. Select one.
Once you get the image control on the form, you can assign it a field in your underlying table.
Your table should hold a path to your images. Normally this path is either the same directory as the one where you plan to install your database, or a subfolder of it. This is for ease of use.
A text field in your table would then hold that path.
example: C:\MyDatabaseLocation\Images\Image1.bmp
Then using the form's On_Current event you assign the image control the value in that text field.
-
Private Sub Form_Current()
-
Me.ImageControl.Picture = Me.MyImagePath
-
End Sub
-
J