I have a report that is going to have 30 odd fields each containing a number, the number is the wind speed.
I want to format the background of the field based on the value of the text box. I have code that formats the background, but I am having issues with it. They are listed below
1. I cannot get it to use # values i.e. #e4fefc
2. I can only get it to format when I put in detail_click, detail_format does not seem to work
3. When I click on a line all the other fields are formatted according to that selected lines value not it’s own value.
This is the code I am using
Expand|Select|Wrap|Line Numbers
- Select Case WindSpeed_03h.Value
- Case 6
- Me.WindSpeed_03h.BackColor = "#e4fefc"
- Case 7
- Me.WindSpeed_03h.BackColor = "#adfbf7"
- Case 8
- Me.WindSpeed_03h.BackColor = "#9afaf6"
- Case 9
- Me.WindSpeed_03h.BackColor = "#73f8f2"
- Case 10
- Me.WindSpeed_03h.BackColor = "#e4fefc"
- Case 11
- Me.WindSpeed_03h.BackColor = "38fb83"
- Case 12
- Me.WindSpeed_03h.BackColor = "#09fe15"
- Me.WindSpeed_03h.FontBold = True
- Case 13
- Me.WindSpeed_03h.BackColor = "#09fe15"
- Me.WindSpeed_03h.FontBold = True
- Case 14
- Me.WindSpeed_03h.BackColor = "#13fe00"
- Me.WindSpeed_03h.FontBold = True
- Case 15
- Me.WindSpeed_03h.BackColor = "#43fb00"
- Me.WindSpeed_03h.FontBold = True
- End Select
Can someone give me a hand on these problems please.