Runtime error 94 when getting data from a form

From: Gail (anonymous_at_discussions.microsoft.com)
Date: 06/26/04

  • Next message: kdw: "Re: Querying Recordset" 
    Date: Sat, 26 Jun 2004 14:31:35 -0700

    On Access 2003 I have set up a form with a command button
    and an unbound text box. The click command for the button
    has the following code:
    strFromEmail = Forms!frmTest!txtInput.Value
    If I have no default value in the text box, and do not
    enter anything, I get run-time error 94 (Invalid use of
    Null) when I click the button.
    I got round this by entering "" as the default value.
    But if I have a default value in the text box, then the
    user deletes the whole string, I again get run-time error
    94 when the button is clicked.
    I must be missing something very basic about how to get
    input from a form. Please could someone help.

  • Next message: kdw: "Re: Querying Recordset"