If FormatCount = 1 then
Debug.Print pg_lngTotCredits
If pg_lngTotCredits = 0 Then
Me.txtTermStanding = "IN PROGRESS"
Else
Me.txtTermStanding = <some other control which is hidden with the field data required>
End If

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.

<<Just wondering if you would know why, if in the above example
there are 3 groups,

yet the group format event got triggered 5 times
>>

It's what I was refering to above in my first comment. Based on properties, like Keep together, the report engine may need to retreat up the page and reformat it again. This can happen several times in the course of trying to figure out the page layout honoring (if it can) all the properties that have been set.

This can happen for the detail as well as any of the grouping levels. That's why both OnFormat and OnPrint events have counts (FormatCount and PrintCount).

Featured Post

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…

Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…