Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error handling in report controls? (Access XP/SQL Svr 2000 SP-3)

    I have a few reports that use simple formulas as data sources for Access text boxes. A representative calculation looks like this:

    =(Actual/Budget)*100

    When the user hasn't yet entered a value for the Budget field, I get errors on the report. In Excel it's really easy to trap for these conditions. Is there a similar way in Access?

    Thanks,

    Keith

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error handling in report controls? (Access XP/SQL Svr 2000 SP-3)

    kastorff
    Check the following post, this should provide your answer:-

    <post#=289481>post 289481</post#>

Posting Permissions

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