Results 1 to 4 of 4

Thread: init. an array?

  1. Dec 12th, 2006, 10:47 AM #1
    mapperkids
    mapperkids is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Posts
    269

    init. an array?

    Hi,

    I have a muti-dimension array and would like to init it everytime a form is load?

    do I have to loop through it like below or quicker way to do


    For i=1 to 2000

    array(i).field1 = ""
    array(i).field2 = ""

    next i


    Thanks!
    Reply With Quote Reply With Quote
  2. Dec 12th, 2006, 10:49 AM #2
    krtxmrtz
    krtxmrtz is offline
    vbuggy krtxmrtz's Avatar
    Join Date
    May 2002
    Location
    In a probability cloud
    Posts
    5,573

    Re: init. an array?

    Quote Originally Posted by mapperkids
    Hi,

    I have a muti-dimension array and would like to init it everytime a form is load?

    do I have to loop through it like below or quicker way to do


    For i=1 to 2000

    array(i).field1 = ""
    array(i).field2 = ""

    next i


    Thanks!
    If you use arrays of variable dimension (and the ReDim statement) you can erase them after they've been used.
    Lottery is a tax on people who are bad at maths
    If only mosquitoes sucked fat instead of blood...
    To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
    Reply With Quote Reply With Quote
  3. Dec 12th, 2006, 01:15 PM #3
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: init. an array?

    See if this works for you:
    VB Code:
    1. Erase array
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  4. Dec 12th, 2006, 02:33 PM #4
    sigid
    sigid is offline
    Addicted Member sigid's Avatar
    Join Date
    May 2006
    Location
    Massachusetts, USA
    Posts
    182

    Re: init. an array?

    ...and keep in mind that the array is already initialized during the form load with each cell set to its default value (where strings = "" and numbers = 0)
    If you to initialize it again after the form load, I second SI's suggestion to use ERASE ARRAY (if the array is static) or REDIM ARRAY if it is dynamic...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width