[AccessD] Access Arrays

[Gustav Brock]

Hi Arthur

You can dim it:

Dim MyArray(0 To 99) As Long

All elements will hold a zero.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces at databaseadvisors.com> På vegne af Arthur Fuller
Sendt: 23. oktober 2018 17:00
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: [AccessD] Access Arrays

It's been a while (too long!) since I've done any actual coding in Access, and it seems I've forgotten almost everything I once knew. Case in point:
arrays.

How do I create an array with 100 elements? x = Array(100) gives me an array of one element, not an array of 100 elements.

Also, can I create an array of 100 elements, each of which is a Long?

Your friendly old fart in Toronto.

--
Arthur