Re: [MSAccessProfessionals] On Load or On Current populate fields on a report for printing

If you mean that some records will display one field and others a different one, neither event.  You'd use the format event of the detail section (or whatever section contains the controls).  Also, nothing is "=" to Null; you'd use the IsNull() function.

Paul

------ Original Message ------

From: "michael simpson via groups.io" <saccity101=yahoo.com@groups.io>

To: "MSAccessProfessionals@groups.io" <MSAccessProfessionals@groups.io>

Sent: 10/12/2021 7:39:59 AM

Subject: [MSAccessProfessionals] On Load or On Current populate fields on a report for printing

Good morning - 

Due to personal issues I've not worked on my software for too long... 

Hoping to get back on the task... 

I've not worked much with reports, and I have never been clear on when to use on load, and on current procedures.  

Specifically I have a form that I sent to a report and then print.. 

Several of the fields may be blank, for example the Warranty Note, 95% of the work orders use a standard note, the remainder will have something other.. 

If Warranty Note = Null Then 

    Standard Note

Else 

    Custom Note

End If

Should this be in the On Load or On current event procedure

Take care,

Mike the Plumber

Sac City Plumbing