# sign added to end of value (97)

Topic

New Reply

When I type:

tempSAP = 60614907704

I get this instead:

tempSAP = 60614907704#

Could someone explain please?

Reply | Quote

Replies

Phase of the moon — check the Help topic titled, “Silly things that happen during a diurnal moon.”

When you’re keying in the value, are you keying it directly into a table, into a form field, the VBA IDE? If a table, form or query, what is the data type of the underlying field? If you’re keying it into a form field, is there an event of any sort associated with the control that might cause the pound/sharp sign to be appended? Are you keying in just the numeric value in your original post, or the whole text string, “tempSAP = 60614907704”? A little more info, please.

Reply | Quote

Now I understand why things systematically go wrong at certain times of the month… (Oops, Sorry, Wrong Moon….)

Reply | Quote

I checked when I first saw the message – it happens to me in VBA in Access 2000. One thing I did notice is that it is too big to be a long integer (i.e. greater than 2147483647) but doesn’t have a decimal point. Maybe Access is confused about what type it should be?

Reply | Quote

tempSAP is of long integer type being written in a code module.

Reply | Quote

Then, like I said, it won’t fit. Long ints hold integers from -2147483648 to 2147483647.

Reply | Quote

Have a look in Help for Double Data Type, it is described:

Double (double-precision floating-point) variables are stored as IEEE 64-bit (8-byte) floating-point numbers ranging in value from -1.79769313486232E308 to -4.94065645841247E-324 for negative values and from 4.94065645841247E-324 to 1.79769313486232E308 for positive values. The type-declaration character for Double is the number sign (#).

Pat

Reply | Quote

So…

Dim dblTest1 as Double
Dim dblTest2 as Double
Dim dblTest3 as Double
dblTest1 = 2147483647
dblTest2 = 2147483648#
dblTest3 = 60614907704#
Debug.Print dblTest3 * 2

..even though the IDE places the # at the end of the values, the actual value will be used in calculations. Interesting. Good catch, Pat!

Reply | Quote

Thanks Shane,
And how is beautiful Minneapolis these days, I spent about 5 months there from Feb/75 thru Jun/75 and I loved it.
Pat

Reply | Quote