G
Gail
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.
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.