Dynamically Resize Pictures

L

Lyle

I am using Access 2003 to create a catalog of books and music. Each picture is "zoomed", which is what I want, except the "extra" space becomes a solid white which conflicts with my background. Is it possible to programmatically shrink the width or height (depending on whether the picture was zoomed vertically or horizontally) of the image? Here's what I'm using so far
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer
On Error Resume Nex
Me![DisplayImage].Picture = Me![ImagePathPrefix] & "No Image Available.jpg
Me![DisplayImage].Picture = Me![ImagePathPrefix] & Me![CPID] & ".jpg

End Sub
 
Top