I am creating a "TempTable" from a Template Table. The template serves as my base table and a temp table is created to serve as a form's recordsource in each unique user session. I use the method in many systems. Works fine. In this case, I'm having a FORMAT transfer problem. I have three fields set up as "CHECKBOXES". When I run the make temp table procedure these fields populate as "Text Boxes"...they lose their CheckBox property. Why is this happening? How can I make the "Make Temp Table" procedure retain ALL the property settings of the Template Table?

Are you running a Create Table statement or a Select Into statement.

If you are using Make Table a "checkbox" is a Bit type field.

This works. Thank You!