Number list

[XXD]

Hi
I have a form in "table form" and I have inserted a textbox as a new column in the form. I want the textbox to show how many lines appears in the form.

It's hard to explain but it looks 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 textbox data: =Antal(*) & "." (The language is in Swedish, so, Antal stands for quantity.)

Thank you

 

[RuralGuy]

I think I understand and you may find this link helpful.

 

[wiklendt]

wow - i read a post on this very thing just yesterday! see if this helps:

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=309

 

[missinglinq]

I'm glad you posted that link,wiklendt! I saw this thread and went to retrieve the link from my help files and couldn't find it! I, too, came across this hack in the last couple of days, and could have sworn I put it in a file, but cannot find it. I can usually lay my fingers on a file for any subject in less than a minute, but I guess I'm slowing down! My help files just topped 1600!

I've made note of Allan's contribution also!

Linq

 

[RuralGuy]

Doesn't Stephan Lebans' link do the same thing as Rogers?

 

[wiklendt]

sorry RuralGuy, i didn't see your post before i posted mine - i often open heaps of windows when i'm online, then go offline if i have to, say, change trains on my way to work. while i'm offline i read the posts, type in a "quick reply" then send when i'm hooked back up to the net. i usually refresh first to make sure someone else hasn't replied in the meantime, but obviously my system is imperfect

but the other thing is that the roger link has working examples, which, for a novice like me is the mecca in being able to piece together how something should work...

 

[RuralGuy]

Not a problem at all. I was just double checking my reference. BTW, I love the idea of Woy Woy. Fair dinkum mate.

 

[XXD]

Thank you for the help.
Is there no simpler way to do that, like the one I found to count the quantity of rows?

I thought the examples you gave me were good but way to complicated for such a simple question.

 

[wiklendt]

i know you can get row/line numbers in reports by putting in an unbound textbox, entering into it "=1", then setting the data properties of the textbox of "running sum" to be over group - have you investigated if there is something similar that can be done for datasheet view of forms?

 

[XXD]

Yes, I tried to find that in forms too, but couldn't find it. It only works in reports.