Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Increment a text box in an Access Report

Posted on 2003-03-20
Medium Priority
Last Modified: 2012-06-27
   My issue:
        I have generated a report in Access, I have a text box that I need to increment by 1 starting at any given number.  I haven't found much help on the web dealing with this case, I have tried several options in getting the accomplished.  The running sum option would be great if I could start at 1 on every report.  So think of it like this, I need the running sum functionality but starting with a variable provided by a query.
Question by:jsatt200
LVL 41

Accepted Solution

shanesuebsahakarn earned 520 total points
ID: 8177995
Create a hidden text box (ie Visible property set to No), set its control source to =1, and then set its RunningSum property to whatever you want.

Now, in the text box where you want to display the value, set its control source to something like:

Where MyHiddenTextBox is the name of the running sum text box and 200 is your start value (less 1).

Author Comment

ID: 8181276
Why didn't I think of that.  
Thank you shanesuebsahakarn.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

580 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