anyone good on Mircosoft Access 2007? -(Tick box)

  JUSTDANCE 18:50 28 Mar 10

I have a tick box in a field set up, by having the data type as "Yes/No", which is a tick box in the datasheet view.

Now the question is that,
is there a way of that tick box being ticked/checked automatically if another field contains "£0.00"???

So basically i would like the tick box ticked automatically when the other field in the same table has £0.00 in it.
Is that possible?

If so, how do i do it???

Any questions, feel free to ask.

Thank you so much!

  JUSTDANCE 20:34 28 Mar 10


  Woolwell 21:08 28 Mar 10

I'm sorry but I haven't got time to look at this now but I suspect that you need to make your check box a calculated field using an expression.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5