Turning Red?

[Mike.Howard79]

Hi All,

I need a date field on a form to turn red if, in another field the check box is ticked (ie Visually says completed)

For the check box field i am using a yes/no and for the date field i am using date/time.

I hope this makes sense

Cheers

Mike

 

[Norie]

Mike

Do you only want this to happen when the checkbox is clicked?

Is the checkbox unbound or is it bound to a field in the datasource?

If it's unbound then this small piece of code should do what you want.

Option Compare Database
Option Explicit
 
Private Sub Check8_Click()
    Me.RealDate.BackColor = IIf(Check8.value, vbRed, vbWhite)
End Sub

If it is bound you could probably use the AfterUpdate event and/or the form's load event.

You could also use conditional formatting in later versions of Access.

 

[Mike.Howard79]

Only when the check box is ticked and yes it is bound to another field within the same table as the date field

Hope this helps

 

[Norie]

Well, I've not had time to check the bound part but try the code I've already posted in the meantime.

I'll check out the bound thing and post back - my only real concern there was what would happen when the form opened.

A different event would probably needed, perhaps one or both of the ones I mentioned.

Do you know if you can use conditional formatting?

If you can you wouldn't need any code at all and it should work with bound/unbound controls.

PS Not 100% sure about that last part - only recently found you could use conditional formatting on forms in Access 2010. Not sure if it's a good thing or bad thing.

 

[revans]

You'll want to check if the checkbox is null (so use Nz(MyCheckbox,False)). You can use either the Click or AfterUpdate events. You will also want to use the form's OnCurrent event so when you scroll between records the field will be colored appropriately.

hth,

Rich