Calculated field showing #Error

[davesmith202]

I have this formula for my calculated field:

=[Bar Deposit Comments] & " Bar Deposit: " & CStr([Bar Deposit (incl VAT)])

For some reason, it is showing an error in the memo field.

Is it a problem because its a memo field or have I missed something here?

Thanks,

Dave

 

[davesmith202]

I found out the problem. The calculated field was called Bar Deposit Comments which messed with it! Doh!