I have a table that is created by a make-table query.
One of the fields is a Yes/No data type, which is populated by using an Iif equation.
The user is given access to edit the table, specifically to set some of the "No" values to "Yes".
I have no problems with this, other than wanting to improve the useability to the user: currently the Yes/No field is displayed as
-1 or 0. I want to show it as a check box, so reducing the no. of clicks & keyboard strokes to one click.
I know how to set that by viewing the table in design mode, but don't want the user to do this. Instead, I want to set the display control for the field to "Check box" using VB code, but can't find out how to do it.

Any bright sparks out there know how to do this?

My advice is that you don't give users the ability to edit the table directly. That's a big no-no. Create a form that will have the fields you want them to edit, including that Yes/No field, and let them check/uncheck it THERE.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division