Solved

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

Posted on 2014-01-07
3
490 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

738 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