Command button Back Color (1 Viewer)

kirkm

Registered User.
Local time
Today, 21:12
Joined
Oct 30, 2008
Messages
1,257
There is a command button property in Access 2019 for Back Color but it doesn't work. Should it ?
From Googling I see some suggestions , one is to use a rectangle - but you can't have text in a rectangle control can you ?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:12
Joined
Oct 29, 2018
Messages
21,358
Hi. I'm not in front of a computer now but isn't BackColor the color of the button because ForeColor is the color of the Text?
 

kirkm

Registered User.
Local time
Today, 21:12
Joined
Oct 30, 2008
Messages
1,257
Yes, except it doesn't work. Or does it for you ?
 

kirkm

Registered User.
Local time
Today, 21:12
Joined
Oct 30, 2008
Messages
1,257
My Command button properties don't seem to include "Use Theme"
Do you need to install it or something? What tab should it show up on ?
Thanks.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:12
Joined
Oct 29, 2018
Messages
21,358
My Command button properties don't seem to include "Use Theme"
Do you need to install it or something? What tab should it show up on ?
Thanks.
Hi. Nothing to install, it should be under the Format tab. However, I am currently looking at 2016, but I don't think it was taken out in 2019.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 04:12
Joined
Feb 19, 2002
Messages
42,981
On the Format Ribbon, choose the Quick Styles Icon. I formatted just the green button. It has a picture on it. Text works also.
 

Attachments

  • FormattedButton.JPG
    FormattedButton.JPG
    74.3 KB · Views: 280

kirkm

Registered User.
Local time
Today, 21:12
Joined
Oct 30, 2008
Messages
1,257
On the Format Tab for Command Button I get:

Caption
Picture Caption Arrangement
Visible
Picture Type
Picture
Width
Height
Top
Left
Back Style
Transparent
Back Color
Border Style
Border Width
Border Color
Font Name
Font Size
Alignment
Font Weight
Font Underline
Font Italic
Fore Color
Hyperlink Address
Hyperlink SubAddress
Hyperlink Target
Gridline Style Top
Gridline Style Bottom
Gridline style Left
Gridline Style Right
Gridline Width Top
Gridline Width Bottom
Gridline Width Left
Gridline Width Right
Top Padding
Bottom Padding
Left Padding
Right Padding
Horizontal Anchor
Vertical Anchor
Display When
Reading Order


And on the Ribbon, under Format, Quick Styles is greyed out (as are most things there).
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:12
Joined
Oct 29, 2018
Messages
21,358
Hi. I know you said you're using Access 2019, can I also ask if you're trying to modify a MDB file? Just curious...
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 04:12
Joined
Feb 19, 2002
Messages
42,981
Aha! theDBGuy has gotten to the crux of the problem:)
 

kirkm

Registered User.
Local time
Today, 21:12
Joined
Oct 30, 2008
Messages
1,257
Ahh, yes I am. All my Access files are ",mdb" extension and I've kept it as I've got later versions... starting from Office 97, if I recall correctly.
So this determines what features are available?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:12
Joined
Oct 29, 2018
Messages
21,358
Ahh, yes I am. All my Access files are ",mdb" extension and I've kept it as I've got later versions... starting from Office 97, if I recall correctly.
So this determines what features are available?

Correct. The file format determines what features are applicable. In your case, if you don't want to use ACCDB, you might look for an ActiveX equivalent.
 

kirkm

Registered User.
Local time
Today, 21:12
Joined
Oct 30, 2008
Messages
1,257
Not sure about Active-X, haven't really had a need to learn about it. Perhaps I should redo it from scratch as accdb.

Thanks for putting me straight...
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:12
Joined
Oct 29, 2018
Messages
21,358
Not sure about Active-X, haven't really had a need to learn about it. Perhaps I should redo it from scratch as accdb.

Thanks for putting me straight...

Hi. You're welcome. Good luck with your project.
 

kirkm

Registered User.
Local time
Today, 21:12
Joined
Oct 30, 2008
Messages
1,257
I tested this in a new accdb file and the color did change. But why does the color and the caption disappear when you mouse over it?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:12
Joined
Oct 29, 2018
Messages
21,358
I tested this in a new accdb file and the color did change. But why does the color and the caption disappear when you mouse over it?

Hi. There's also a Hover color. Try adjusting it.
 

kirkm

Registered User.
Local time
Today, 21:12
Joined
Oct 30, 2008
Messages
1,257
Thanks DB Guy.. found that and a few more properties and have it all set up nicely.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:12
Joined
Oct 29, 2018
Messages
21,358
Thanks DB Guy.. found that and a few more properties and have it all set up nicely.
Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
 

Users who are viewing this thread

Top Bottom