Meaning of: VariableName = 0#

[Mark Hammer]

I've inherited some code where the developer initializes some fields to 0#.

Can someone tell me the significance of the #? How is that different from
setting them to zero?

TIA,

Mark Hammer
Lake Oswego, Oregon, U.S.

 

['69 Camaro]

Hi, Mark.

The # sign after a number signifies a double data type, which requires eight
bytes for storage. Without the # sign after a number, the computer will use
the default number data type, which is long (four bytes for storage) for a
32-bit operating system.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Andi Mayer]

I've inherited some code where the developer initializes some fields to 0#.

Can someone tell me the significance of the #? How is that different from
setting them to zero?

a small difference: the # marks this number as double dataType

 

[Tim Ferguson]

a small difference: the # marks this number as double dataType

It's a huge difference if you are going to add 0.5 to it...


Tim F

 

[Mark Hammer]

Ah-HAH! Good thing to know! Thanks All.

--Mark Hammer