Stopping blank fields showing

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

Guest

Is it possible to stop fields with a null value showing in an access report?
Or Maybe i could somehow set up a "if value is null, dont show" type option
 
Really depends on what you are trying to do.

One approach is to set the "Can Grow" & "Can Shrink" properties to "Yes" for
the controls and the section.

Another would be more code-intensive -- you'd use the Format event to
evaluate each field and set its corresponding control's Visible property to
"No" if there was no value (i.e., "null").

--
Good luck

Jeff Boyce
<Access MVP>

shootdamonkey said:
Is it possible to stop fields with a null value showing in an access report?
Or Maybe i could somehow set up a "if value is null, dont show" type
Click to expand...
option
 
if you want to write the code you would have to have something similar to
this for every text box and label you didn't want to see.
KB


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If TotalPcs.Value = 0 Then
TotalPcs.Visible = False
PcsLBL.Visible = False
MailingCost.Visible = False
Else
TotalPcs.Visible = True
PcsLBL.Visible = True
MailingCost.Visible = True
End If
End Sub
 
Back
Top