Flip image in report

[rmm1]

I would like a form or a report to display images - the images are loaded from a folder based on the current record

One of those images need to be flipped vertically and another one has to be rotated 90 degrees.

Is there a control out there that will do this for me.

Or is there some simple code that will do this as the image is being loaded.

Thanks in advance.

[June7]

So the image control doesn't automatically adjust for the image dimensions?

Couple ways this might be done with code.

One would require setting the dimensions and position properties of the image control. The unit of measure for some is twips (1 inch = 1440 twips). Example:
Me.boxMask.Height = 10710 'twips
Me.boxMask.Top = 4320 'twips
Me.tbxBox1.Left = 0.25 'not twips
Me.tbxBox1.Width = 11520 'twips

Another would mean having two image controls bound to the same data and setting visibility.

Some criteria would be needed to determine which orientation is appropriate.

For a report, both options would be coded in the Format event of whatever section the controls are in. On a form, code in form Open event.

[rmm1]

Thanks,
But I wanted the image to be automatically flipped vertically (OR rotated through 90 degrees) when comes into the IMAGE control.

I may be wrong but the code you outlined is for resizing and positioning only isn't it?

[June7]

Okay, my misunderstanding. Not sure can do that with Access. Why not edit the image with an image editor (like Paint) to rotate and save it with the desired orientation? Check this thread http://bytes.com/topic/access/answer...rotating-image

[rmm1]

Pity I thought maybe they would have made this an option by Access 2010.

I found a control called DBPix which can do this with some code - but I am waiting for them to email back and tell me if I can do this with code (pref a sample code) or HOPEFULLY a property in the control.

I used to have a control that worked with ACCESS 97 but now that I am running WIN 64-bit the API doesn't work/register anymore. So back to square one.