Transparent background on form controls (1 Viewer)

Chrisopia

Registered User.
Local time
Yesterday, 17:20
Joined
Jul 18, 2008
Messages
279
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

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?
 

Users who are viewing this thread

Top Bottom