Boolean Fields

[DeanFran]

Maybe I'm not conversant enough in this data type, but this type of field seems to make using it in forms and reports cumbersome. I often create databases that are to be used by folks that are much more familiar with the look and feel of Excel, and they love their Y/N or Yes/No columns. They always complain when a form or report has the check box. My answer to this is to create a Yes/No helper table and use it in a combo on forms, and displaying the text in reports seems to make everyone happy. Am I making this too hard?

 

[Uncle Gizmo]

Am I making this too hard?

I don't think so. You have to cater for your users wimes wherever reasonably possible.

 

[MarkK]

...a Yes/No helper table...

What is a Yes/No helper table?

To show a boolean field as Yes or No in a combo, you can just set the combo properties to...

• RowSourceType = 'Value List'
• RowSource = 0;No;-1;Yes
• ColumnCount = 2
• ColumnWidths = 0";2"
• ControlSource = YourBooleanFieldName

Then the combo doesn't have to do any disk access to display its options.
hth
Mark