I am creating a colour coded check list for pending invoices, I have made a continuous form, and placed a box behind. The box will become a different colour depending on the status of the invoice
Quite straight forward, except when a control is current, e.g. you are editing the values, the control becomes white, which is quite ugly!
the controls are transparent, the colours from the 'BackBox' show through... just until you click on it.
Now I tried setting the colours of the controls individually, but access couldn't cope and it crashed.
I also had "enabled = no, locked = yes" on, but they render the controls unclickable... and I need them clickable...
Is there another way to force transparency on a control?
Code:
If IsNull(Me.Total_Due) Then 'Invoice is still open e.g. unfinished
Me.BackBox.BackColor = vbCyan
ElseIf IsNull(Me.Proof_Date) Then 'The job is still being proofed
Me.BackBox.BackColor = vbMagenta
ElseIf IsNull(Me.Delivery_Date) Then 'The job is in production
Me.BackBox.BackColor = vbGreen
ElseIf Me.Delivery_Date > Date - 28 Then 'The job is waiting payment
Me.BackBox.BackColor = vbYellow
ElseIf Me.Delivery_Date < Date - 28 Then 'Payment is over due
Me.BackBox.BackColor = vbRed
Else
Me.BackBox.BackColor = vbWhite
End If
Quite straight forward, except when a control is current, e.g. you are editing the values, the control becomes white, which is quite ugly!
the controls are transparent, the colours from the 'BackBox' show through... just until you click on it.
Now I tried setting the colours of the controls individually, but access couldn't cope and it crashed.
I also had "enabled = no, locked = yes" on, but they render the controls unclickable... and I need them clickable...
Is there another way to force transparency on a control?