Refer to a control by its index

[RBohannon]

I found this in the Help file:
' Refer to a control by its index in the controls
' collection.
Me(0)

Can I view a list of controls on a form and see their index numbers?
Or how do I find the index numbers?

Thanks.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Including your previous post:

The usual way to use control arrays in Access is to name controls
something like "txtField1," "txtField2," etc. Then iterate thru them
like this:

dim i as integer

for i = 1 to 2
Debug.Print Me("txtField" & i)
next i

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS+WeIechKqOuFEgEQKkqwCgi6aMvKMJnD1+VaTNvTE43j x1dIYAn1gA
O6Xk1Pt/OGIzlP/MhJLGpfkz
=TBcA
-----END PGP SIGNATURE-----

RBohannon wrote:

I found this in the Help file:
' Refer to a control by its index in the controls
' collection.
Me(0)

Can I view a list of controls on a form and see their index numbers?
Or how do I find the index numbers?

Thanks.

[Bob Quintal]

ra*****@hotmail.com (RBohannon) wrote in
news:ad**************************@posting.google.c om:

I found this in the Help file:
' Refer to a control by its index in the controls
' collection.
Me(0)

Can I view a list of controls on a form and see their index
numbers? Or how do I find the index numbers?

Thanks.

You can loop through the index collection and return each name.
--
Bob Quintal

PA is y I've altered my email address.