Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009

    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.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    I'm not sure it will solve you problem, but you could try:
    =nz(Me.[Total Deposits].Value)-nz(Me.[Total Withdrawals].Value)
    Also, did you check if no reference was missing in the 2007 version?
    Have a nice day!

  3. #3
    Join Date
    Apr 2009

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts