How can i show Row Numbers in the TextBox

**L_ter** · 03-16-2009, 07:15 AM

Hi,

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.

Like:

1. The title1 more text1
2. The title2 more text2
3.
4.... and so on.

I am able to get the amount of lines by entering this to the data of the textbox:

=Antal(*) & "."

but how can i show the row number in the textbox.

Please reply??

**ExlGuru** · 04-21-2009, 07:19 AM

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:

Please Login or Register  to view this content.

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