J
John
I am trying to produce a report from a database of
clearance stock. Some of the records have associated
pictures and some do not.
I am using an image frame that links to a path in a field
in each record to the picture rather than have the
pictures in the table itself which makes the database
enormous!
The pronlem I have is that the image frame properties do
not have a can shrink, can grow option so when there is
no image with a product the report still leaves a large
gap before the next item.
The image and product description etc are in the Detail
section of the form. Although I have set the can
shrink/grow properties to yes for the detail section,
still when no image is present the same gap is left.
I have even written an on format event for the report
using an if elseif statement that looks for a file path
in the assosited field and if the field is empty it sets
the size value of the image frame to a negliigable size
and guess what? this didnt work either!!
Can anyone help?
clearance stock. Some of the records have associated
pictures and some do not.
I am using an image frame that links to a path in a field
in each record to the picture rather than have the
pictures in the table itself which makes the database
enormous!
The pronlem I have is that the image frame properties do
not have a can shrink, can grow option so when there is
no image with a product the report still leaves a large
gap before the next item.
The image and product description etc are in the Detail
section of the form. Although I have set the can
shrink/grow properties to yes for the detail section,
still when no image is present the same gap is left.
I have even written an on format event for the report
using an if elseif statement that looks for a file path
in the assosited field and if the field is empty it sets
the size value of the image frame to a negliigable size
and guess what? this didnt work either!!
Can anyone help?