var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access 2003 to 2007 form problem
On a form I have a text box named "Balance"
The control source is:
=nz([Total Deposits])-nz([Total Withdrawals])
It works without problem when opened in Access 2003 but not when opened in 2007, what is wrong and is there a solution I can use.
I'm not sure it will solve you problem, but you could try:
Also, did you check if no reference was missing in the 2007 version?
=nz(Me.[Total Deposits].Value)-nz(Me.[Total Withdrawals].Value)
Have a nice day!
Thanks for that... it looks a good solution
Thanks for that it... looks a good solution.
I have about 12 databases that I created in earlier versions of Access, all work without 2007 installed. So I think my best solution is to uninstall 2007 and continue using Access 2003, as I could have similar problems with the others.