resize a picture to fit into an Acccess 2000 report
Posted on 2004-11-04
I'm writing a program where the user has the option to select a picture from their computer and it will be added to their report. The problem is that the size image that the user selects may be a different size than the Image Control on the Report (approx. 6" x 6"). I'm using Access 2000 / VBA
I am trying to:
1. Determine if the user selected a file that was in a valid file format (.jpg .bmp)
2. Determine the size of the image that the user selected.
3. If the picture that the user selected is too BIG for the Image Control on the Report, then resize the picture to fit into the Image Control
4. If the picture that the user selected is too SMALL for the Image Control on the Report, then don't do anything (I don't want to stretch smaller images).
Sorry for the multi-part question... I couldn't think of any other way to ask it.