Bound Object Frame in form

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Thanks for the help in advance!
This involves embedding linked images in a Frame in an
Access form.

- I have a form pointing to a table. This table has a
field ('photoname') containing the path and filename of
jpeg images in a Windows directory.

- I wish to create a Frame that references the 'photoname'
field and shows the corresponding jpeg image as that
record is viewed. Therefore, I created a Bound Object
Frame, using the 'photoname' field as the Control Source.
I then selected 'Linked' as the OLE Type Allowed.

My problem is that the image referenced in the 'photoname'
field does not show up. Which Data Format does
the 'photoname' field need to be? When I choose 'OLE
Object' as the Data Format, the path in the field
disappears and becomes 'Long binary data'. The format
doesn't work as a Hyperlink or

Text either. Please help!

Chris
 
Hi Chris

i like to suggest using Image control to show the JPEG image. These are the guidelines

- Add an Image Control to your form. It will ask you to insert picture. Dont worry we'll delete it later on. So, select a valid image. Click OK to close the dialog box
- Goto the Image control properties called Picture on tab Format. Delete whatever text in it. Answer Yes, if you were asked 'do you want to remove picture'. You can also set other properties llike border, etc

Now, add this line of code to your Form Current Event

Me.YourImageControlName.Picture = Nz(Me.PhotoName, ""

and, probably to your Form AfterUpdate Event too

The Bound Object Frame is used when you, for example, store the actual JPEG image on the table, say in fields Image. The datatype of fields Image should be OLE Object.

Hope this helps
 
Back
Top