Don't store the picture in the table. Keep it external in the file system and just store the path/filename
Resizing is problematic and some formats work better than others. You may have to stretch an image that can distort it.
Use the Image control to display the image.
>What is the best way to allow my users to:
>
>a. Select a picture to upload to a specific record (i.e. product)
>b. Automatically resize the photo
>c. Display photo on screen (form).
>
>If they upload multiple photos, i want to allow them the capability to scroll through the pictures while maintaining the dimensions of the picture on the screen/form.
>
>Is it "cleaner" to simply create a table (mypictable) and capture the full path and photo filename?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer