VBA - Control Back Color Property

[pedie]

Hi, small question.... till now whenever i want to set the back color of the control i use vbblue,vbgreen etc...
Now when i check access control background it has lots of color number and while doing some research i found that we can use something like RGB(84, 1, 6) which 'm not familiar to.
If i want to use backColor #84A1C6 how do i use it in RGB way?

Thanks in advance

[/FONT]
[FONT=Courier New]Me.Label18.BackColor = RGB(84, 1, 6) '#84A1C6[/FONT]
[FONT=Courier New]

 

[pedie]

What is Command0? Does it have a BackColor property?

property is set to normal from transperant.

 

[Norie]

Pedie

How exactly did you create the button?

Does it have a picture on it?

PS You can actually use vbRed instead of RGB or the Hex value for the colour.

 

[xenou]

I didn't think you could change button colors in Access ... I might be wrong!

I just tried it on a button in Access and no effect was visible when I displayed the form (even though I could set the back color property to this, that and the other.

Pedie, you have so many more things to worry about than the color of your buttons ... grey is just fine, as long as the button can be clicked! Let's focus here. Are you learning SQL? Are you studying database design principles? Forget about whether buttons are red, green, or blue ...

Note:
specifically:

Sub Command0_Click
    Me.Command0.BackColor = vbRed
    DoCmd.Repaint '//For good measure ...
    DoEvents  '//Just to be sure ...  
End Sub

Button stubbornly looks the same ...

 

[Norie]

xenou

You definitely can change the back colour(s) of a button, though in Access 2010 it's all a bit strange.

I tried earlier with a button that I'd set to one of the 'Access Theme' type things.

I put some code in it's Click event to change it to vbRed.

When I clicked it nothing seemed to happen, but when I moved away the colour changed to red.

When I moved back it changed to another colour, kind of a toggle thing maybe.

I liked it when Access was simple, when you used a wizard it created a form that was easy to change.

Now you have to Remove Layout before you can even move labels/controls about.

And don't talk to me about Multiple Items forms.

 

[pedie]

Pedie, you have so many more things to worry about than the color of your buttons ... grey is just fine, as long as the button can be clicked! Let's focus here. Are you learning SQL? Are you studying database design principles? Forget about whether buttons are red, green, or blue ...

Xen, thank for answering back...yep the button color is of no imporatance no matter how it looks....

and yes, 'm learning sql[the query sql 'm referring to]...and also 'm referring to w3 link you refferred me other day. But yes 'm still in trail and error stage...

Norie, i think there is some problem in access, i tried both way even vbred and still error and .backcolor line..however thats okay...it'll still work without it happening.


Thanks again guys!!!

 

[Norie]

Pedie

Is it definitely s command button on a form?

What happens when you delete it and add a new command button?

How are you viewing the form?

Is the form with the button a subform on another form?

 

[HiTechCoach]

This might help:

Create Color Command Button Sets

Tired of boring grey command buttons? This demo allows the user to create web-style command button sets with graphics of your choosing, exported automatically to your database. TRY IT, YOU'LL LIKE IT!

 

[Norie]

Boyd

Perhaps I'm mistaken but that doesn't really create buttons.

 

[pedie]

Boyd, thank you for demo file, yes it is cool [image as button] and the mouse event....Thanks alot!

 

[HiTechCoach]

You're welcome.

Glad you find it useful.