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
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
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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.
Suggested Courses

765 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