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

  • Thread starter Thread starter Thomas Henke
  • Start date Start date
T

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
 
Try

F_3 = CLng(F_1) + CLng(F_2)
Click to expand...

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
 
Thomas Henke said:
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?
Click to expand...

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!)
 
Back
Top