Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2003
    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
    Thanked 28 Times in 28 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