Murugesh Perumal
asked on
Running Number in the Ms access report is not displayed properly.
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.
Thanks,
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.
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
Running sum is working for all 4 views,