Image Control SizeToFit

[chrisse_2]

Hey,

Sorry about all the image posts its just that i need to get this to
work!!!

- I've already posted about the CanShrink and CanGrow option for image
controls. This is a no go! What if i create another field, in the table
with the images, which has the
dimensions of each image, is there any code i can write in the report
to change the size of the image, control for each image, based on the
dimensions of the
image?

- I just discovered the SizeToFit option for some control and i believe
it should work for images. You can only use it in design view of the
report but i can't seem to find it for the image control. Can anyone
help me!

Thanks again!!!

Christina

[bob]

You can scale an image control in the report’s “Detail_Format” event by setting the controls’ .Width and
.Height properties according to the image dimensions (you’ll need to work out a suitable scaling factor).
You can also set the height of the detail section, for example:

Me.Section(acDetail).Height = 1234

Note that the Detail section can’t be shrunk smaller than the size needed to fully contain any controls
on it, so shrink/move the controls first.

--
__________________________________________________ _____
DBPix 2.0: Add pictures to Access, Easily & Efficiently
http://www.ammara.com/dbpix/access.html


ch*******@hotmail.com wrote:

Hey,

Sorry about all the image posts its just that i need to get this to
work!!!

- I've already posted about the CanShrink and CanGrow option for image
controls. This is a no go! What if i create another field, in the table
with the images, which has the
dimensions of each image, is there any code i can write in the report
to change the size of the image, control for each image, based on the
dimensions of the
image?

- I just discovered the SizeToFit option for some control and i believe
it should work for images. You can only use it in design view of the
report but i can't seem to find it for the image control. Can anyone
help me!

Thanks again!!!

Christina

[chrisse_2]

Hey,

bob wrote:

You can scale an image control in the report's "Detail_Format" event by setting the controls' .Width and
.Height properties according to the image dimensions (you'll need to work out a suitable scaling factor).

How do you set the image controls width and height properties? I have
the values for the height a width the table with the image.

Thanks,

Christina

[bob]

How do you set the image controls width and height properties? I have
the values for the height a width the table with the image.
Image1.Width = somevalue
Image1.Height = someothervalue

Where Image1 is the name of your image control.

Here’s a full example.

You’ll need to work out the value of ImgScale according to the largest image size you need to handle.

FixedHeight is the height of the detail section if there is no image

Image1 is the image control.

ImgWidth is the field containing the image width (in pixels).
ImgHeight is the field containing the image height (in pixels).

ImgWidth and ImgHeight must be included on the report, otherwise the data values are not available. The
text boxes can be hidden though.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Const ImgScale As Integer = 5
Const FixedHeight As Integer = 100

If IsNull(Me!ImgWidth) Then
Image1.Width = 0
Else
Image1.Width = Me!ImgWidth * ImgScale
End If

If IsNull(Me!ImgHeight) Then
Image1.Height = 0
Me.Section(acDetail).Height = FixedHeight
Else
Image1.Height = Me!ImgHeight * ImgScale
Me.Section(acDetail).Height = Me!ImgHeight * ImgScale + FixedHeight
End If

End Sub
--
__________________________________________________ _____
DBPix 2.0: Add pictures to Access, Easily & Efficiently
http://www.ammara.com/dbpix/access.html


ch*******@hotmail.com wrote:Hey,

bob wrote:

You can scale an image control in the report's "Detail_Format" event by setting the controls' .Width and .Height properties according to the image dimensions (you'll need to work out a suitable scaling factor).

How do you set the image controls width and height properties? I have
the values for the height a width the table with the image.

Thanks,

Christina

[chrisse_2]

Thank you so much! I really appreciate your help.

cheers,

Christina