Changing Picture on Command Button

[kdbailey]

I'm looking to change the picture on my command button between access default pictures. First "Filter", second "Filter by Form".



For the life of me I cannot figure out how to change the Picture property, as it is set to "(Image)" no matter what I choose, and I cannot find another property in which it directs to an embedded file somewhere.

Anybody know how to switch back and forth? I'd really prefer not to have to make 2 buttons.

[Bulzie]

So you have a button that as an image(instead of text) and you want to change the picture to another picture when they click on it?

[kdbailey]

In a nutshell, yes.

The images are embedded in Access already, not external pictures.

[Bulzie]

Do you have to use pictures, why not just use words and change them as needed by the .caption property?

If me.control1.caption = "Filter" then

me.control1.caption = "Filter By Form"

Else

me.control1.caption = "Filter"

End If

Or you could use 2 buttons, one on top of the otther. When they click the first one, do the process then make it invisible and the other button visible. Put same code in for 2nd button as well.

There are picture properties on a control when you do it in code Me.Piccontrol1.Picture

[kdbailey]

Caption is not viable and I'm trying to avoid two versions of the same command buttons. There are 11 of these buttons currently.

As for the .Picture property, it's value is consistently "(Image)" if you select one of the embedded access pictures.

If I need to, I'll create the second buttons, but would prefer not to.

[Bulzie]

Do you have to an image instead of text?

[Micron]

Don't know how to get at or alter this property, but my suggestion would be to have 2 image controls laid over the button. Show one and hide the other according to the need.

[Bulzie]

If you can save the bmp images for those 2 actions to a folder on network on local PC, try this code on the button.

Me.YourButton.Picture = "C:\AA\aa.bmp"

So to switch them maybe:
If Me.YourButton.Picture = "C:\AA\Filter.bmp" then

Me.YourButton.Picture = "C:\AA\FilterByForm.bmp"

Else

Me.YourButton.Picture = "C:\AA\Filter.bmp"

End If

[Micron]

found a sample db for retrieving table stored pics here in post #8; haven't had time to look at it much.
Apparently, it doesn't require a lot of table overhead and seems to provide a way to store your chosen pics. Mostly I don't advocate storing images in tables, but this db is only about 300k with a few forms and a table with 2 images, so that seems OK.

[Shadow9449]

If I may make a suggestion:

- put 2 buttons on the form and hide them. Let's call them cmdFilter and cmdFilterbyForm
- Set the picture on each to the Access button picture you want.
- When you want your command button to show the picture of one or the other just use: Me.CommandButton.PictureData = Me.cmdFilter.PictureData or Me.CommandButton.PictureData = Me.cmdFilterbyForm.PictureData

That will dynamically change the picture to the one you want. I hope I understood the question correctly!