HOW DO I PRINT ONLY THE FORM IN ACCESS 2007?

  • Thread starter Thread starter scotsman
  • Start date Start date
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.
 
Back
Top