Empty an Array

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 04 Feb 2006 20:22 GMT

Thanks for taking the time to read my question.

Just wondering how to empty an array after it has values in it.

Thanks,

Brad

Reply to this Message

Douglas J. Steele - 04 Feb 2006 21:11 GMT

Erase MyArrayName

Note that if it was originally declared as a dynamic array, this erases all
memory used by the array, so you'll have to ReDim it before you use it.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Thanks for taking the time to read my question.
>
[quoted text clipped - 3 lines]
>
> Brad

Reply to this Message

Stephen Lebans - 05 Feb 2006 00:57 GMT

I don't think I ever knew that Doug.
Thanks.

:-)

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> Erase MyArrayName
>
[quoted text clipped - 9 lines]
>>
>> Brad

Reply to this Message

Douglas J. Steele - 05 Feb 2006 13:07 GMT

I've known it for a while. I just always forget it when I need to use it!
<g>

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I don't think I ever knew that Doug.
> Thanks.
[quoted text clipped - 13 lines]
>>>
>>> Brad

Reply to this Message