You can use Ubound and Lbound to establish how many elements there are in the Array.
However I am not sure why you are using VBA & an Array to do what you are doing, or what you trying to achieve.
The one thing that you need to forget when working with Access is how things are done in Excel.
Access is designed for data handling and although VBA Recordsets are extremely powerful so are SQL queries.