Search results

  1. B

    Allowing an Empty String "" in a textbox.

    Modifying the Default Value was not working, so after messing around with several ideas I used the OnChange Event for the text box. Private Sub Background_Color_Change() If IsNull(Background_Color) Or Background_Color.Text = "" Then Background_Color.Value = "" End If End Sub...
  2. B

    Allowing an Empty String "" in a textbox.

    I have tried using a space and "" as the default value. Neither works, I have also tried to enter a space In the field and I am still generating the same error message.
  3. B

    Allowing an Empty String "" in a textbox.

    Hello, I have an Access 2010 database where we have a SQL Linked Table with a column that is nVARCHAR(20) Not Null data type. We have created a form for data entry. Currently when the user tries to erase a value or choose not to define a value we get the following error. "You tried to...
  4. B

    Solution: Kind of 'UnCrosstab' code

    Hey guys I know this is an old post... but I wanted to give credit for the code. I was wondering if you could expand on how to utilize this code. I have created a public function in my module. But I am not sure on how to call it. I get the error: on this line: Set rstout =...
Top Bottom