I'm quite new to access. I need to create tables using queries - which I can do - no problems there. however, you know how you can define the display control (textbox, listbox, checkbox etc.) in the design view for each field? I would like to be able to specify that for each field using a create table query. :confused: Does anyone know how to do that? Any help appreciated!!

Sorry, but you are not going to be able to set these parameters in a Make Table query. I will look into setting them with code.