Changing the background color of a control

A

Abay

Hello ... I use the following code to change the background color of a
control when the value in another control (total) is > 0

If Dair_trans > 0 Then
Ddesc.BackStyle = 1
Ddesc.BackColor = vbRed
Else
Ddesc.BackStyle = 0

End If

When I click Ddesc and the value of total is > 0 the color changes on all
the lines (a multiline form) regardless of the value of the total control

Is there a way to change the colour of the control in question only if the
condition is met and for it to say colored .. ie the control on that line
only is changed.

Any help would be most appreciate.

Abay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Conditional formatting of detail section in an access form 2
Control Background Color 2
Tab Control Color Question 1
DateDiff Conditional Formating 2
Access 2010 Form Background Color Not Changing with Themes 1
how to set the Default Value of a Control Box to a Lookup Table 0
Conditional formatting of a subform's background color 4

Top