Re: Problem with adding values in control

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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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!