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]

 

[shg]

If RGB color 84A1C6 is what you want,

Me.Label18.BackColor = &H84A1C6

 

[pedie]

shg, thats what i was looking for. Thanks alot!

If RGB color 84A1C6 is what you want,

Me.Label18.BackColor = &H84A1C6

 

[shg]

You're welcome, pedie.

 

[pedie]

You're welcome, pedie.

Can we change the backcolor of Button in access? For now 'm using Label with back color as button

Sorry to bring this up again.

 

[Norie]

Pedie

Quick answer, yes.

PS Why are you using labels for buttons anyway?

 

[pedie]

It does not allow me to when i tried.
Please show me one simple example...

Thanks Norie

Pedie

Quick answer, yes.

PS Why are you using labels for buttons anyway?

 

[Norie]

Pedie

How did you try?

The only code you would need would be what shg posted, changing the name of course.

eg change Me.Label18 to Me.Command2367

 

[pedie]

Tried this way: errors ", Comile error; Method of data member not found.

[/FONT]
[FONT=Courier New]Private Sub Command1_Click()
Me.Command0.BackColor = &H84A1C6
End Sub

 

[shg]

What is Command0? Does it have a BackColor property?