Pictures on Forms

[RicM]

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...?

 

[fredg]

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...?

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]