Solved

Running Number in the Ms access report is not displayed properly.

Posted on 2014-01-07
3
480 Views
Last Modified: 2014-02-10
Hi,
   
In the ms access Report i need to get the row number for each row and set it as 'sl no'.
I have placed a text box in the Report and Set the control source as '=1’ and made Running sum as over Group.
   I am unable to see the previous value of the last row. When I set the focus I am able to view it.
   Ex. Refer screenshot
   There are 3 rows. The 'sl no' of 2nd row is show blank on opening the screen. When focus is set on 'sl no' column of 2nd row, I can view the value '2'.
Please let me know why the value is invisible for the first time. This happens always on the last but one row.
Row number 2 is missingonce the focus is set. Row number 2  is getting displayedThanks,
0
Comment
Question by:Murugesh Perumal
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 39761793
Report view really doesn't work correcly in a numer of circumstances and this is one of them.

You should find in report preview or printing it that the numbers always display and display correctly.

Jim.
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39761840
Unable to reproduce the issue.
Running sum is working for all 4 views,
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39789993
Agree with both posts above.

I have seen issue with "memory" being an issue here:
...Low video memory, low system memory, low resources,...etc

Or in some cases the other calculations (or formatting, or vba code, graphics, ...etc) on the report prevent the running sums from rendering properly.

JeffCoachman
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now