Pictures on Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RicM - 19 Jan 2008 17:36 GMT

I have a recipe database, with a picture of each recipe stored with each
record. I add the picture by right-clicking the OLE frame on the form and
inserting it from file.
Any reason why, once I reach 57 records, the new pictures suddenly become
icons with the picture name displayed, instead of the full picture (as per
the previous 56 records)? I haven't change ANYTHING in the program settings,
and I do not have the 'display as an icon' box ticked...?

Reply to this Message

fredg - 19 Jan 2008 20:59 GMT

> I have a recipe database, with a picture of each recipe stored with each
> record. I add the picture by right-clicking the OLE frame on the form and
[quoted text clipped - 3 lines]
> the previous 56 records)? I haven't change ANYTHING in the program settings,
> and I do not have the 'display as an icon' box ticked...?

Instead of storing the image itself in the database, store the all the
images in a different folder on your hard drive, i.e.
c:\RecipeImageFolder

Then, in your table, store the Image name in a regular text field,
i.e. Veal Parmagian.jpg

Then on your form, add an Image control. Leave it's Picture property
blank (Add the control using any picture. Save the control. Then
Delete the Picture property.)
Code the Form's Current event:
Me.ImageName.Picture = "c:\RecepeImageFolder" & "\" &
Me.[TextFieldName]

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message