CODEWITHSUNDEEP
vbams-access
BeardedSith
BeardedSith

Reputation: 129

Yes/No data type always displaying as True/False - Boolean formatting issues

I have several fields on a form that absolutely will not display a boolean value which is set to display as Yes/No, the dropdown menu is set to only offer Yes/No as options, but no matter what I do, the values displayed on the form always show True/False instead. Pictures below:

Showing False
Options with False still showing Data type in the table design

At this point I'm not entirely sure what it is that's causing this, but it's kind of annoying.

Upvotes: 1

Views: 1992

Answers (1)

Olivier Jacot-Descombes
Olivier Jacot-Descombes

Reputation: 112592

If you want to use a ComboBox, set the ComboBox properties as follows

In the data section:

Control Source = <name of your table or query column>
Row Source Type = Value List
Row Source = -1;Yes;0;No    ' Alternating values and texts.
Bound Column = 1
Limit To List = Yes

In the format section

Column Count = 2          ' Because we have a value and a text.
Column Widths = 0cm       ' This makes the first column invisible.

Upvotes: 1

Related Questions