We help IT Professionals succeed at work.

VB5 - Bound PictureBox Control

lankford
lankford asked
on
Medium Priority
404 Views
Last Modified: 2013-11-26
Hello all,

I have noticed the properties for a picturebox control that allow the programmer to bind it to a recordset control (datafield and datasource).  I have a sample database (Access version 2) with a table containing a field of type "Ole Object" containing bitmap data.

I thought that if I bound a picture box to this field in a recordset that it would display the image stored in the database when moving throughout the dataset.  I was wrong.  

What can you do realistically with the datafield and datasource properties of a picturebox?  In other words, what is the intened use of these properties?  Is there an way to bind a picture box control to a database containing images so that when moving through the dataset, you can easily browse the images in the database?

Thanks,

Robert
867-5309
Comment
Watch Question

Commented:
The only way we've ever found load the picture property is through the use of the loadpicture function:

PicBox.Picture=LoadPicture("C:\Pict.bmp")  

Which means you have to getchunk out the bmp, write it to a file, then use the loadpicture function to set the .picture property of your picture box.

Using the .datafield and .recordsource properties of the picturebox, you can generalize a function to get the image from the database to a file, then loadpicture it into the picture property.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.