Concatenation - mysterious space appears???

  • Thread starter Thread starter disneygoof via AccessMonster.com
  • Start date Start date
D

disneygoof via AccessMonster.com

This is a really good one...I have been trying all sorts of different
combinations and I get the same result each time. NOW with this said, I did
solve this problem and I am offering this to everyone for FYI. Feel free to
verify this and let me know WHY???? this is happening, I fixed it but I don't
know why it's happening

below is my code..partial...

inlen = Me.DummyNum.SelLength
numVal = left(DummyNum, inlen - 1)
If IsNumeric(numVal) Then
inval = numVal
Me.Number = inval
Me.Num = str(inval) & Me.SubNum & Me.Type
Me.DummyNum = str(inval) & Me.Type
Else...

Without going into too much detail, you see two TEXTBOX fiels 'Num" and
DummyNum"...don't ask...
The only difference between the two is the "SUBNUM" field (this is letter: a,
b, c, etc)

ISSUE:
The 'DummyNum' field, after concatenation, is somehting like "20E"...without
the quotes.
The 'Num' field, after concatenation, comes out somehting like " 20aE"...
without the quotes..note the leading space infront of the "20".

SOLUTION:
I got rid of the str(inval) and just used 'inval'.
Keep in mind, I do not get his issue with the "DummyNum" field using str
(inval)....

All comments are welcome. I am courious as to WHY this is happening...
 
The Str function puts a space in front of positive numbers. That space
contains a - sign for negative numbers.
 
Agreed...but why does it work in the one case ond not the other? Both
conditions yield positive numbers, but on the one condition gives me the
space... I read this, but it did not explain what I am seeing....?
David
The Str function puts a space in front of positive numbers. That space
contains a - sign for negative numbers.
This is a really good one...I have been trying all sorts of different
combinations and I get the same result each time. NOW with this said, I
Click to expand...
[quoted text clipped - 35 lines]
All comments are welcome. I am courious as to WHY this is happening...
Click to expand...
Click to expand...
 
Perhaps dummum is consider a number field?

it be that your 20E is conseridered a scientific notation number...

? isnumeric( "hello" )
False

? isnumeric(123)
True

? isnumeric(20E2)
True

Perhaps the expression is being evaluated as number, or there is some type
of format on the text box (number, and it getting converted to a number..and
hence the space goes away).
 
Makes sense, I did not think about scientific notation...thank you.
D.
 
Thank you
D.
Change str(inval) To Cstr(inval)
This is a really good one...I have been trying all sorts of different
combinations and I get the same result each time. NOW with this said, I did
Click to expand...
[quoted text clipped - 30 lines]
All comments are welcome. I am courious as to WHY this is happening...
Click to expand...
Click to expand...
 
Back
Top