suppress empty cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When printing in form view, can an empty field be suppressed so it doesn't
print out an empty box.
 
Forms aren't intended for printing: that's what Reports are for.

I don't believe it's possible to do what you're trying to do on a form.
 
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"
 
Just as a guess, how about in the command button to print the form

If IsNull(Me.txtSomeCtl) Then
Me.txtSomeCtl.DisplayWhen = 2
Else
Me.txtSomeCtl.DisplayWhen = 0
End If

Of course I am assuming there is such a button.
 
Yeah, that would work for a form in Single Form view. It wouldn't work, of
course, for one in Continuous Form or Datasheet view.
 
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.
 
Back
Top