How many fields in an array?

[MagnumXL]

I honestly did search for an answer to this.

I know it should be simple and that the solution is probably staring me in the face.

I need to return the number of fields there are in an array as a variable.

Ultimately (where the need comes from) I need to know how many Fields (Columns) there are in an Access table. But i can already return the table in an array so either answer would really help me. Thank you in advance.

[Valuater]

$Array_Count = UBound($array)

see help

8)

[MagnumXL]

Awesome, thank you! I guess i dont feel too bad now. Whats the logic behind calling this "UBound"?

[randallc]

Awesome, thank you! I guess i dont feel too bad now. Whats the logic behind calling this "UBound"?

Hi,

For number columns; $Array_Count = UBound($array,2)

See helpfile;

Best, randall

[Valuater]

Welcome!

and ...I dont know why!

maybe, if you are going to use ubound() you might want to use ubound() -1

Remember that the value returned by UBound is one greater than the index of an array's last element!

8)