This is part of my Animal Welfare Database being developed in Microsoft Access Office 365.
The segment I am working on is the Animal Welfare section where the attendant makes decisions about the welfare of a rescue cat and records these decisions by ticking checkboxes [] associated with a ]YES/NO[ field set next to labels, and a couple of small comment text fields (not shown here).
e.g. Neuter Required [] ]NO[ 'the brackets are for illustration only here, for checkbox and small associated text field'
When a checkbox is ticked, the associated textbox shows YES. (or you can type YES into the associated textbox, which ticks the Checkbox)
If you click on the checkbox's associated textbox, you can see the -1 or, if unticked 0, for YES and NO respectively. (Type in anything else and you will get an information box saying that's not a valid input. Click OK and clear the error.)
So, using another button to Post the result shown in the checkbox's associated textbox (i.e. Yes) to the WelfarePlan text field I used (extract only shown)
"Neuter Required: " & Me.NeuterRequired
this then results in
Neuter Required: -1
being reported in the targeted WelfarePlan textbox.
What I want to do is have this item shown as
Neuter Required: Yes
Can you help me with this please?