[AccessD] Determine the number of columns in an array

Mark

The following lines

Dim intX(3, 5) As Integer
MsgBox UBound(intX, 1)				'the ,1 is optional as
it's the default
MsgBox UBound(intX, 2)

show 3 then 5. Was it one of those you wanted?

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark H
> Sent: 03 July 2003 16:32
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Determine the number of columns in an array
> 
> 
> Hello all...
> 
> Sorry if this is a bit simple, but I'm in a bit of a rush to 
> get out and wanted to ask before I go (climbing - yippeeee)...
> 
> Anyway, does anyone know how to determine the number of 
> columns in an array? I am trying to write a bit of generic 
> code and want to be able to pass the array and then figure 
> out its width. I looked in the helps "See also" under Lbound 
> and Ubound but found nothing...
> 
> Thanks in advance
> 
> Mark
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>