Problem with adding values in control

[amelia170]

I have an unbound text box that is supposed to add the previous fields
to display a total.

the text box has the controlsource of:
=([finances]+[leisure]+[visitfriends]+[leisurealone]+[bestfriend]+[outsideshopping])

instead of displaying a total, it displays each individual value.

(instead of 6 which is 1+1+1+1+1+1 it displays 111111)

Ideas? Thanks!

[DFS]

Try Sum(cDbl(finances) + cDbl(visitFriends) + .... )

or set the Format property of each text box to one of the number types, and
you can leave off the cDbl() part

Sum([finances]+[leisure]+[visitfriends]+[leisurealone]+[bestfriend]+[outside
shopping])
"amelia170" <lv********@bpacal.com> wrote in message
news:3d**************************@posting.google.c om...

I have an unbound text box that is supposed to add the previous fields
to display a total.

the text box has the controlsource of:
=([finances]+[leisure]+[visitfriends]+[leisurealone]+[bestfriend]+[outsidesh
opping])
instead of displaying a total, it displays each individual value.

(instead of 6 which is 1+1+1+1+1+1 it displays 111111)

Ideas? Thanks!