Re: [MSAccessProfessionals] Report, when field blank look up standard note

In addition to Paul's comments, I will sometimes use a text box in place of a label. For instance, if there is a field [MaidenName] that might be null, you could use a text box for the label with the control source of:

="Maiden Name: " + [MaidenName]

Make sure the width of the text box is just wide enough to show the quoted text. If the field is null, the entire expression becomes null.

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of michael simpson via groups.io <saccity101=yahoo.com@groups.io>
Sent: Tuesday, August 16, 2022 4:01 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Report, when field blank look up standard note

 

Good day - 

I am working on updating automating my database to send out invoices, 

I have two issues, 

I have a Form (fmWO) which I publish to a report (rptWO) and then print to a PDF to email to clients. 

First I generally us a standard warranty on my work orders, so I don't type it in unless something atypical. 

Want to if field WarrantyNote = "" then lookup standard note. 

Second issue: if some fields are not filled in then hide the label and message box 

First thought was to put something on the on load event, however, getting "invalid use of Null" error.

The on current event is triggered when I close the form,  

Take care,

Mike the Plumber

Sac City Plumbing

_._,_._,_