Tick box value

[xnatty89xx]

I know this is probably a fairly simple question but i am relatively new to databases.
I have created a database for a riding school which records when people book a lesson, if they have paid a tick box in a filed named "paid" is ticked to say they have done so. There is also a field named "money owed" which I wish to display the amount a person owes if they have not paid for the lesson.
I was wondering if it is possible to give a value to a check box whilst it is unchecked, which will be displayed in the amount owed field? Any help is much appreciated.

[Rabbit]

A checkbox by itself only has the value True or False. You can assign values with an option group but that requires multiple checkboxes. You could use VBA to assign values using a If checkbox = True Then ...

[NeoPa]

I know this is probably a fairly simple question but i am relatively new to databases.
I have created a database for a riding school which records when people book a lesson, if they have paid a tick box in a filed named "paid" is ticked to say they have done so. There is also a field named "money owed" which I wish to display the amount a person owes if they have not paid for the lesson.
I was wondering if it is possible to give a value to a check box whilst it is unchecked, which will be displayed in the amount owed field? Any help is much appreciated.

It may be better to store any values in your record as numerical or currency type fields. This can then be shown as a CheckBox by entering a formula dependent on the value stored.