Using Variable Arrays For Field Names in MS Access 2000 ??

[NeilFrank]

I noted with interest that in Access 2000, it is legal to give several fields the same name by using variable array notation. For example, I can set up a table with 3 fields named Field(1), Field(2), and Field(3).

However, I am subsequently unable to reference these fields using the normal ! notation.

For example, when I write:

For intCount = 1 To 3
!Field(intCount) = mintArray(intCount)
Next intCount

or even when I try eg:

!Field(1) = mintArray(1)

I get an "Item cannot be found in the collection corresponding to the requested name or ordinal" error.

Help!