Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    North Dakota, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clng Function (Access 2000)

    Simple question...

    What's the Clng function used for? I can't find it in the help.

    Thanks.
    Sarah

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Clng Function (Access 2000)

    From Access 97 help.

    Function Return Type Range for expression argument
    CBool Boolean Any valid string or numeric expression.
    CInt Integer -32,768 to 32,767; fractions are rounded.
    CLng Long -2,147,483,648 to 2,147,483,647; fractions are rounded.

    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clng Function (Access 2000)

    It's in the Access 2000 help. Go to visual basic (Alt-F11), bring up the help, and use the index to find clng.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clng Function (Access 2000)

    You can find all the conversion functions, including CLng, by opening Help from the VBE (Alt+F11), switching to the Answer Wizard tab, and typing in conversion functions.
    Charlotte

Posting Permissions

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