changing background multipleform

[gunterhoflack]

I would like change the color of the background of the detail of a continuous form, recording to the value I have in a textbox ...; Is this possible

for example: value : gren ==> background must be green
value = geel ==> background must be yellow .....

How can I do this through programming ??

[Missinglinq]

You can't do this with a Textbox, you need to be able to limit the Values entered to those you have programmed for, spelled correctly. A simple way would be to create a Combobox, entering the Plain Language Names for the Colors.

Then, in the AfterUpdate event of the Combobox use something like this, using the VBA Constants for Colors:

Private Sub ComboName_AfterUpdate()
 
 Select Case ComboName

 Case "Red"
   Me.Detail.BackColor = vbRed
 
 Case "White"
   Me.Detail.BackColor = vbWhite

 Case "Blue"
   Me.Detail.BackColor = vbBlue
 
 End Select

End Sub

Linq ;0)>

[gunterhoflack]

Create a [B]Combobox, entering the Plain Language Names for the Colors

Then, in the AfterUpdate event of the Combobox use something like this, using the VBA Constants for Colors:

Private Sub ComboName_AfterUpdate()
 
 Select Case ComboName

 Case "Red"
   Me.Detail.BackColor = vbRed
 
 Case "White"
   Me.Detail.BackColor = vbWhite

 Case "Blue"
   Me.Detail.BackColor = vbBlue
 
 End Select

End Sub

Linq ;0)>

Hello I don't think this is a solution because this is a continu form. And the value , red, white, blue, are fields coming from a query .... so the backcolor should different for every line in the form ......
I don't know on which event event I should do it.
I should use case panelcolour.value and that in a case statement, but I don't know which event I could use for a continuous form

greetz.
gunter

[Missinglinq]

Sorry, but I know of no way to set the BackColor of a Form's Detail Section, on a Continuous View Form, so that it changes on a Record-by-Record basis. There is only one Detail Section, and what it's set to is what it's set to!

Linq ;0)>

[gunterhoflack]

Sorry, but I know of no way to set the BackColor of a Form's Detail Section, on a Continuous View Form, so that it changes on a Record-by-Record basis. There is only one Detail Section, and what it's set to is what it's set to!

Linq ;0)>

Could it be solved by adding a rectangle, and change its color, record by record based on the value of the colour ??

but which event should I use ?

[Missinglinq]

No, Rectangles are Unbound Controls, and the same rule applies; the Rectangle on all Records is going to be formatted the same as the one on the Current Record.

Doing almost any kind of formatting in a Continuous Form requires using the Conditional Formatting Wizard; it cannot be done in code, using events. You could try something like

1. Placing a Textbox, under all of the Controls.
2. Bind it to a Field in the underlying Table/Query
3. Leave it unpopulated
4. Send it to Back
5. Right Click on the Textbox
6. Click on Conditional Formatting
7. Under ConditionX, select Expression Is
8. In the next box enter: [YourFieldName] = "Green"
9. Use the BackColor Icon (looks like a bucket of paint) to select Green from the Palette
10. Hit 'Add'
11. Repeat Steps 7-10 for each color
12. When completed, hit 'OK'

I've seen this done, but never thought it looked very professional, to be honest. But, as they say in the ads, your results may vary! And in Access 2010, I believe you now have the ability to set 50 Conditions, a huge improvement over the old limit of three plus a default condition!

Linq ;0)>

[gunterhoflack]

No, Rectangles are Unbound Controls, and the same rule applies; the Rectangle on all Records is going to be formatted the same as the one on the Current Record.

Doing almost any kind of formatting in a Continuous Form requires using the Conditional Formatting Wizard; it cannot be done in code, using events. You could try something like

1. Placing a Textbox, under all of the Controls.
2. Bind it to a Field in the underlying Table/Query
3. Leave it unpopulated
4. Send it to Back
5. Right Click on the Textbox
6. Click on Conditional Formatting
7. Under ConditionX, select Expression Is
8. In the next box enter: [YourFieldName] = "Green"
9. Use the BackColor Icon (looks like a bucket of paint) to select Green from the Palette
10. Hit 'Add'
11. Repeat Steps 7-10 for each color
12. When completed, hit 'OK'

I've seen this done, but never thought it looked very professional, to be honest. But, as they say in the ads, your results may vary! And in Access 2010, I believe you now have the ability to set 50 Conditions, a huge improvement over the old limit of three plus a default condition!

Linq ;0)>

tnx a lot this did the trick for me.......

[Missinglinq]

Glad it works for you!

Good luck with your project!

Linq ;0)>