Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: if field is left unchanged

    I have a field that has a default of "00000000-000". I'd like the field to return to a null value if it still equals the "00000000-000" when leaving the field. I tried using:

    Private Sub Co_RskNo_LostFocus()
    If [Co_RskNo] = "00000000-000" Then
    [Co_RskNo] = ""
    End If
    End Sub


    but I get a debug error on the [co_rskno]=""
    I'm sure my use of "" does not equal a null value here. Any ideas?

  2. #2
    Join Date
    Jul 2002
    Posts
    15
    So you want the field to be null? Have you tried

    Private Sub Co_RskNo_LostFocus()
    If [Co_RskNo] = "00000000-000" Then
    [Co_RskNo] = Null
    End If
    End Sub

    ??

    Not sure if that will help or not.

Posting Permissions

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