What's bigger than a long?

[grande]

I have a long that's overflowing. What can I do?

Dim lngCount as Long

-------------------------
Just call me Captain Awesome.

 

[SkipVought]

grande,

Have you checked out VBA Help?

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[Blorf]

F1 and search for fieldsize, or cheat and take a look at

http://msdn.microsoft.com/library/d...us/vbaac11/html/acproFieldSize_HV05187225.asp

Double is likely your answer though,

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[SkipVought]

Double would be my LAST choice. Significant loss of precision!

There are other options!

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[Blorf]

Hi SkipVought.

After re-reviewing the list, I don't see an obvious options. Can you explain? Is there an option for unsigned long intergers?

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[SkipVought]

Variant,
Byte,
Boolean,
Integer,
Long,
Single,
Double,
Currency,
Decimal,
Date,
Object, and
String

So which ones did you eliminate?

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[Ed2020]

If I remember correctly Currency (and possibly decimal) are actually stored as integer values and (again if I remember correctly) potentially provide space for larger numbers than long.

Double is often best avoided despite apparantly being able to store the highest/lowest numeric value as numbers beyond a certain value are stored and expressed in standard form. You will also experience floating point errors in doubles (and singles). A lot of the time this will make no difference, but it can have a significant effect in certain scenarios.

Ed Metcalfe.

Please do not feed the trolls.....