Results 1 to 2 of 2

Thread: text box error

  1. #1
    Join Date
    Oct 2007

    Unanswered: text box error

    I have a text box making a calculation, but until a value is entered into 2 different text boxes I get an "#Error" display. How can I hide the #Error until the values are entered?

    I have this function in the control source of the text box I am getting the error in:

    Round(DateDiff("n", #12:00:00 AM#, Format(TimeIn - 1 - TimeOut, "Short Time")) / 60,2)

  2. #2
    Join Date
    Mar 2007
    IIF(IsDate(Me.OtherControlName),Round(DateDiff("n" , #12:00:00 AM#, Format(TimeIn - 1 - TimeOut, "Short Time")) / 60,2),"")
    ...using *your* OtherControlName of course.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

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