Help counting Rows in a list.

L

Lipoio

I have already a table in Listbox, stil i was wondering if there was an
expression or function so i can get the number of records in the list. So i
can display this number in another text box . I know is quite a starter
question but i can´t find the function or a solution to this problem. Someone
with an advice??.
 
P

Peter Hibbs

In the Control Source property of your text box enter :-

=[YourListBoxName].ListCount

Change the name of YourListBoxName to whatever your list box is
called. Also change the Enabled property to No and the Locked property
to Yes in the text box so users can't try and change it.

HTH

Peter Hibbs.
 
L

Lipoio

Thanks a lot Peter. I appreciate it.

Peter said:
In the Control Source property of your text box enter :-

=[YourListBoxName].ListCount

Change the name of YourListBoxName to whatever your list box is
called. Also change the Enabled property to No and the Locked property
to Yes in the text box so users can't try and change it.

HTH

Peter Hibbs.
I have already a table in Listbox, stil i was wondering if there was an
expression or function so i can get the number of records in the list. So i
can display this number in another text box . I know is quite a starter
question but i can´t find the function or a solution to this problem. Someone
with an advice??.
Click to expand...
Click to expand...
 
Top