Active or Inactive

[CHEECO]

I have a database that has a check box to mark a member active or inactive. I would like to change that so in no longer shows a box with a check mark in to show a member active. I want it to say "Active" if the member is active and say "Inactive" if the member is inactive. How would I go about changing this. I am using Access 2016.

[June7]

Would have to use a text type field to show text "Active" or "Inactive" or a multi-column combobox to display the text alias.

Or an expression in textbox ControlSource to convert the Boolean values to text, in which case the control would not be editable so this would be used on a report.

Review: http://allenbrowne.com/NoYesNo.html

More informative than Yes/No field would be a DateInactive value.

[CJ_London]

or just create a combobox with a value list of

0;Inactive;-1;Active

column count of 2

bound column 1

hide column 0

[CHEECO]

I got it all figured out. Thanks for your help.