Field Currency Format

[jon159785]

I'm trying to have a form that totals up prices for a user.

the control source for the unbound field on the form is:
=[combooption9].[column](4)+[combooption10].column(4)

If the two numbers were 200 and 500 then this results in 200500 as if it were adding strings together

if I did =[combooption9].[column](4)+ 4
then it works correctly with 204.

I even have the field set as a currency.

Is there anyway around this? Or another way to make this work? I've tried using a button to total the fields when clicked, but the result was the same.

thanks.

 

[PaulF]

Convert to numeric using the Val function and also test for Null to prevent errors

=Val(Nz([combooption9].column(4),0)) + Val(Nz([combooption10].column(4),))

PaulF

 

[jon159785]

Works great. Thanks a lot.