Douglas is correct, forms are for view, entering and editing data. Reports
are for printing. However, you may try using the Display When property of
the control (not a cell, cells are in Excel). I don't know how well it works
since I have never printed a form.
I thought of that, but the only choices are Always, Print Only and Screen
Only. As far as I know, there's no way of setting it for "Screen Only When
Field Is Empty"
I disagree with the statement that forms are not for printing. I find that
they are good for printing single records. The DisplayWhen property is
usually set for screen only for command boxes and other user items that don't
serve any useful purpose when printed. I have a question along the same
topic though. Is it possible to set a control DisplayWhen property to screen
only for a form in Datasheet view?
Sorry, Bob. You are in a very small minority. Most seasoned professionals
would agree forms are not for printing.
You can use a screwdriver as a chisle, but it is much more difficult,
doesn't work as well, and will not do the screwdriver any good.