Change command picture

[wtrimble]

I have a button that has the picture "Sort Ascending" which was chosen from the given list of pictures in Picture Builder. When the button is clicked, I want to change the picture to "Sort Descending", but I'm not sure how to call on this in VBA... Any ideas??

Thanks

 

[Yarp]

I am guessing here, so feel free to ignore me.

Can you create two buttons on the form (one with each picture), and hide the relevant one?

 

[wtrimble]

Yes possibly, but there should be a way to change the picture using "mycommand.picture = " easily. Just not sure where the picture is saved at in Access or how to call on it.

 

[wtrimble]

Nobody knows how to change a picture ??

 

[LPurvis]

Here's a similar thread on this subject.
http://www.access-programmers.co.uk/forums/showthread.php?t=157914

Bear in mind that the internal Access images can't be trivially used at runtime (apart from anything else where they're stored has changed over time).
So hopefully you'll read more carefully than nIGHTmAYOR was able to manage and appreciate this is just a way of gathering the images you want to use first and storing their image data in tables for subsequent convenient retrieval (in an efficient manner).

Cheers.