HOW DO I PRINT ONLY THE FORM IN ACCESS 2007?

  • Thread starter Thread starter scotsman
  • Start date Start date
S

scotsman

I would like to print a blank form in Access 2007, anyone know how to do this?
 
That would work, Karl, but to avoid the hassle of having to deal with the
dummy record in the table, I would suggest a Union query that unions a blank
record.

SELECT FirstField, SecondField, ThirdField FROM tblAnyTable
UNION SELECT Null As FirstField, Null As SecondField, Null As ThirdField
FROM tblAnyTable;

The only issue you will have is that if any of the fields are Yes/No fields,
the blank record will come back with a 0. Good ole' Jet translates Null to 0
for Boolean fields. But this would also be true with a dummy record. But
then it would show as not checked if it is a check box control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top