yes/no field with toggle button

I have a field "Closed" this is a yes/no field, which indicate is the work order is closed or open
in the form i use a toggle button for this field, now i would like to change the caption of the toggle button according to the value of the field, is the field value is yes, show toggle button caption as CLOSED
is the field value is NO show toggle caption as OPEN.
i was using the On click event, but it change the caption for all the records
Any idea how to solve this
best regards
titorober23Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
If this is a Continuous form or datasheet view ... you won't be able to do this, since there is really just one control.

You might try using Conditional Formatting on one of the fields to indicate this.

mx
0
 
titorober23Author Commented:
how is the conditional formatting
0
 
titorober23Author Commented:
This does not work with single view form
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.