You can use the Height and Width properties of the image control in code, so that on an event it sets Me.Picture.Height=2.08" and Me.Picture.Width=2.08". (There are 72 pixels in an inch, so 150 pixels would be 2.08").
You can use the Height and Width properties of the image control in code, so that on an event it sets Me.Picture.Height=2.08" and Me.Picture.Width=2.08". (There are 72 pixels in an inch, so 150 pixels would be 2.08").
No, I mean, really resize the picture. Resizing the actual size of the image. Not just how big access has to show the picture, but like if I have a really huge picture, that it wil be resized to 150x150 so that its only 20KB.
To resize the actual image size (and thus file size) on the hard drive or server from within Access? I don't know a way. Perhaps someone else can help, if there is a way.
Could you perhaps resize the image first, then save the image with the SavePicture property to your hard drive, then change the Picture property of the image to the new filename? Just a thought.
