highlight row depending on what drop down box says (1 Viewer)

murray83 · May 26, 2017

i would like the attached to behave like the following

when status is sent to waiting whole row is highlighted red when done set to green

here is my attempt with a bit of pusdocode

Code:

Private Sub Status_Change()
If satus = ("Done") Then 'row = green
If satus = ("Witing") Then 'row = red
End If
End Sub

Minty · May 26, 2017

Use Conditional formatting https://www.youtube.com/watch?v=9xaF97DuLtg

murray83 · May 26, 2017

im at work and youtube is blocked could you put it into code or would it just be easy to google it ?

Minty · May 26, 2017

Typical - I never link to videos normally my bad...
https://access-programmers.co.uk/forums/showthread.php?t=104795 This thread should help.

Try in the field with your status first, then either apply it to a blank text box behind your row or apply it to every text box - be warned if you have a lot of records the second method can make screen updating slow.

murray83 · May 26, 2017

ok have found and inputted the following

Code:

Private Sub Form_Current()
If Me.Status = "Done" Then
Me.Detail.BackColor = vbGreen
Else
Me.Detail.BackColor = vbRed
End If
End Sub

but it changes the detail on the form not the row on the table it looks ok but would rather it do the row on the table

murray83 · May 26, 2017

cheers minty that second link worked a charm

highlight row depending on what drop down box says (1 Viewer)

murray83

Games Collector

Attachments

Minty

AWF VIP

murray83

Games Collector

Minty

AWF VIP

murray83

Games Collector

Attachments

murray83

Games Collector

Similar threads

Users who are viewing this thread