Printing the form

[Techie]

We are relatively new to MS-Access.
Can any one please help us in solving the following MS
Access queries ?
1. I am using MS Access forms to get the data from the
user and I am using the insert query to insert the value
into the table.

The query is "stQuery = "insert into Work values('" &
Work_Name.Value & "'," & Order_No.Value & ",'" &
Order_Dispatch_date.Value & "')"

The query is failing with Syntax error if the field is
Null. Can any one tell me how the query has to be changed
to insert the values even if the field is null.

2. If I print the form, half of the page goes out of
printable area. Is it possible to make the forms printer
friendly ?

Thanks.

 

[Jim/Chris]

Can you give me more information on you table structure.
What is the primary key?

Forms are for adding, editing and viewing data. Reports
are for printing. Create a report based on your form data.

Jim