How to add "+" to positive values in a textfield?

[Thomas Henke]

Hi NG,

how can I add a leading"+" to positive figures in a textfield in a
form? Later I want to calculate further figures with that textfield.
I have tried the following: using "format()" with "+#,##", but then
the textfield is somehow considered as a string.

Example:

F_1 = "+1,500"
F_2 = "+2,000"
Both figures are numerical and based on figures in a subform.
I want to have: F_3 = F_1 + F_2, here "+3,500", but what I get is:
"+1,500+2,000"

Where is the problem?

Regards,
Thomas

 

[Douglas J. Steele]

Try

F_3 = CLng(F_1) + CLng(F_2)

 

[Thomas Henke]

Try

F_3 = CLng(F_1) + CLng(F_2)

Thanks, that works!

Now, to complicate that: when furthermore adding a kind of "unit" to
those figures, say "m" for "meter" by using <& " m">, so that F_1 will
be "+1,500 m", CLng will not work any longer. Any help here?

Thomas

 

[Douglas J. Steele]

Thanks, that works!

Now, to complicate that: when furthermore adding a kind of "unit" to
those figures, say "m" for "meter" by using <& " m">, so that F_1 will
be "+1,500 m", CLng will not work any longer. Any help here?

You should probably reconsider your design.

Typically you'd have a Quantity field (which would be numeric) and a
UnitOfMeasure field (which would be text). Trying to add text fields
together is seldom a good idea (as you've found!)

 

[Thomas Henke]

You should probably reconsider your design.

It is not exactly what I've expected from my query here ;-) but I will
follow your advise. Thanks!

Thomas