Image control reporting .ImageHeight and ImageWidth = 0

[Jan-Erik]

Hi,


Trying to get the the height and width of Picture (file) showed in an Image Control on a Form (file path & -name in a textfield in db).
The problem is that .ImageHeight and .ImageWidth always return zero.
Tested .jpg; .gif ; .bmp images but always get zero for these two properties.
The form is a show only one record.
Using Access 2013.

Ex:
Private Sub btnTest_Click()
msgbox MyOnlyImageControlOnThisForm.ImageHeight
end sub

What did I miss, please?

Thanks!

Best Regards
Jan

[ItsMe]

I was able to get the following to work...

Debug.Print Me.Image1.ImageHeight
MsgBox Me.Image1.Height

Debug.Print Me.Image1.ImageWidth
MsgBox Me.Image1.Width

Maybe your control is corrupt. By the way, it seems to have returned Twips and not inches or ...

[June7]

1440 TWIPs per inch.

[Jan-Erik]

Thank you ItsMe and June7!
I'll keep trying....
The purpose is only to know if it is a landscape- or portrait oriented picture to select different reports for print so twips is ok.

best regards
Jan

[Jan-Erik]

Hi,
Discovered that the Imageheight and -width properties reports correct if picture file name is loaded into the 'Picture'-property but not when the Image Control is linked to a text field in the DB through 'ControlSource'-property.
Strange to me.
Anyway - a workaround then is possible this way.

Best Regards
Jan

[June7]

Before Image control had a ControlSource property (introduced with Access 2007), dynamic display of images on report required VBA code to set Picture property. Is that the solution you went with?

[ItsMe]

If you need the extended properties of a file on a server or your PC, there may be a way to get the info via a Windows API. Maybe reference Shell in your Access app and go after the file's extended properties.

[Jan-Erik]

Hi June7,
Did a Dirty load into 'Picture'-property of Image when user 'opens' a Picture and stores its path to DB.
While Picture property has Picture file path, I save Image height and -width i DB to use later for filtered (H/W < 1;H/W >=1) report portrait or landscape depending on pic-format.
Then clearing Picture property again