Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

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
0
titorober23
Asked:
titorober23
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0
 
titorober23Author Commented:
This does not work with single view form
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now