Access 2010 - Images on Forms

[dluhop]

The form has a RecordSource of the "card' table. The image path was entered into the a field in the "card" table. PACKAGE is displayed. The field is set as an OLE Object in the table (design view). The form (in design view) displays the path, but not the image.

[dluhop]

Update: The RecordSource of the form is the "card" table. The "card" table (in data sheet view) contains a field "obverse" that points to the full path of the image. The field displays the words: "long binary data". The "card" table in design view has the field "obverse" defined as an OLE Object.

The form in data sheet view shows the image path in the box labelled "obverse".

Going to bed soon. Thanks for your help.

[RuralGuy]

I would use an "Image" control rather than an OLE Control. In the Current Event of the Form put the following code:

Private Sub Form_Current()
    Me.obverse.Picture = Me!obverse
End Sub

...remembering to change the Obverse Control to an Image Control.

[dluhop]

Where do I "use Image control"? I can't find it.

[RuralGuy]

I have it as the last Control in the Controls section of the Design menu. You may have to scroll down in that section.

[dluhop]

I hate to do this to you, but I give up! This is all too confusing. I'm going to create what I want in WORD - it's a lot easier. Thank you for all your effort. I really appreciate it.

[RuralGuy]

Can you post a sample of your db? I'll modify it to display the picture. It really is easy once you've done one.

[dluhop]

Can you send me your e-mail address? Or do I attach the database to the forum?

[dluhop]

Case is closed, thanks to RuralGuy!