Row Numbers

[XXD]

Hello
I want a textbox which is placed in a column in the "table looking form"(like a list). I want the textbox to show the row number of the list.

It shall look something like this:
(textbox)
1. The title1 more text1
2. The title2 more text2
3.
4.... and so on.

I am able to get the ammount of lines by entering this to the data of the textbox: =Antal(*) & "."

Thank you.

 

[ajetrumpet]

I think the easiest way would be to add a column to your table if you don't already have one, as a primary key indicator, that runs in order, from 1 to whatever. include this field on your form, but make it invisble. Then, make a query with this as a new column:

dcount("PK field", "table", "PK field <= " & [PK field of the query]) 
   as [Row Number]

then base your form off the query

Here is an example of how to use a unique field in the table to get the row numbers in a query, then base the continuous form off of that query...

 

[XXD]

I think the easiest way would be to add a column to your table if you don't already have one, as a primary key indicator, that runs in order, from 1 to whatever. include this field on your form, but make it invisble. Then, make a query with this as a new column:

dcount("PK field", "table", "PK field <= " & [PK field of the query]) 
   as [Row Number]

then base your form off the query

Here is an example of how to use a unique field in the table to get the row numbers in a query, then base the continuous form off of that query...

Thank you so much for the help and I appreciate the time you've spend on this.
It works great, a really smart solution.

 

[ajetrumpet]

No problem. Good luck, and I like your name =)

 

[Mike375]

That's a real neat solution.