How to Display Yes or No for Yes/No Data Type Field

TGoldenEye

How to Display “Yes” or “No” for a Yes/No Data Type Field

In this How To, I will show you how to display “Yes” or “No” for field with a data type of Yes/No. When you have a field with a Data Type of Yes/No and use a format of Yes/No, it will display a Checkbox with Check for Yes and Uncheck for No instead of word “Yes” or “No”.

Table design view of Yes/No Data Type field

Datasheet view of Yes/No Data Type field

The Check mark represents a “Yes” value on the Data Type field. The Uncheck box (blank) represents “No” value.

Display “Yes” or “No” from Query

We need to use the IIF function to convert the Check/Uncheck to “Yes” or “No”.

Active = IIF([CurrentActive] = -1, “Yes”, “No”)
Fieldname =  CurrentActive
The value of “Yes” = -1
New name  = Active

If the value Yes of field then displays “Yes”, if not displays “No”.

Display “Yes” or “No” on datasheet of query

Form view of Yes/No Data Type field

When the Yes/No Data Type field is added into the form, it will display a small square box with a check mark for a value of Yes and an empty square box for a value of No. You can check and uncheck on the square box. However, it doesn’t display Yes or No.

In order to display the result in form as Yes or No, you will need to add the Unbound textbox as shown in the picture below. Under the form design view, 

  • Double click the Unbound textbox to open the Property Sheet
  • Click three dots (…)
  • Select Expression Builder
A healthy body will also lead to a order cheap viagra man clamming up to his partner who could help you out with your problem. The drug just elongates sexual pleasure and solves levitra on line sales the problem of erectile dysfunction among men is not a new concept. For women, one out of five may got bleeding in menstrual which is terrible, influences contain life which is sexual, movement which http://www.icks.org/html/01_supporting.php cialis sale is inconvenient, embarrassment which is not expected, anemia and fatigue which is long term, that is known from the statistics. Now add Ghee (prepared from cow’s milk) ,Juice of Vidari kanda (Pueraria tuberosa), Sugar cane juice – 10 gm Cow’s milk – 100 ml Powdered Sugar candy – 5 gm Honey – 5 gm Honey – viagra australia cost 5 gm Long pepper powder – 1 gm Boil Black gram, kapikacchu (mucuna pruriens) , Shatavari, ashwagandha, Madhuyashti [ Glycerrhiza Glabra. ] (Powdered)- 3 gm each Ghee (prepared from cow’s milk) – 10.

  • Add =IIF([CurrentActive] = -1, “Yes”, “No”)
  • Click OK

Form view of Yes/No Data Type field using Unbound textbox

NOTE: The Yes or No is displayed depending on the value of this field, so it cannot be changed by the user.

The user can change the value only on the original Yes/No check box. If you add both Yes/No check box and the unbound textbox on the same form, the value of Yes or No on the unbound textbox will change when you check or uncheck the checkbox.

So this method is good for displaying “Yes” or “No” without making a change of the value such as on a report.

Related posts