Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Restore Null Value (2000)

    I have an Not Isnull() statement in vb code to check if a value has been placed in a (unbound)textbox. If a value is present, 'use it' when establishing a new record.

    My Problem: I want to blank out this value in the textbox after 'using it', that is, remove the text and restore the textboxe's 'status' to Null. I have tryed using me.txtbox = " ". This removes the text but it is NOT null as far as Access is concerned, thus my not isnull() statement is still true even though the textbox is blank on the form.

    Any suggestions?
    Thanks! Ralph

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Restore Null Value (2000)

    The question implies the answer:

    Me.txtBox = Null

Posting Permissions

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