Omit record if blank

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

My database contains a field to be filled in only if required (customer
comments). I want to create a report on this field but do not want it shown
as a blank if the field has not been filled in. can anyone help
 
Jamie said:
My database contains a field to be filled in only if required (customer
comments). I want to create a report on this field but do not want it shown
as a blank if the field has not been filled in. can anyone help
Click to expand...


If you do not want the records with a Null comments field,
then use a query for the report's record source. In the
query, set the comments field's criteria to Is Not Null,

If you want to show all the records, but without blank
comments, then don't use a query criteria. Instead, try
setting the comments text box control AND its section's
CanShrink property to Yes. If the text box has an attached
label, then you also need a lint of code in the section's
Format event procedure:
Me.[the text box].Visible = Not IsNull((Me.[the text box])
 
Back
Top