Calculation not right

  • Thread starter Thread starter A Hopper
  • Start date Start date
A

A Hopper

On an unbound form I have three text boxes (Text254,
Text256, Text258). In the On Click event of Text258 is the
following:
Me.Text258 = Nz(Me.Text254) + Nz(Me.Text256)

When I enter 50 in Text254 and Text256 and click on
Text258 I get the answer of 5050 not 100.

Hope someone can help.

Allan
 
Hello Alan,

Looks like the + sign is concatenating two text fields. Perhaps this would
work:

me.Text258 = Val(Nz(Me.Text254)) + Val(Nz(Me.Text256))

hth,
 
Check the text boxes and make sure they are set to accept
a number, not a text. This could be your problem.
 
Back
Top