Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IsNull (Access 2000)

    Could you help me settle the IsNull event in my code, because i do not know why it does not work. I want to prevent saving and closing the form in case the control typeid is not filled.But id does not function.

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

    Re: IsNull (Access 2000)

    The Default Value property of the TypeID field in the table is 0, so when you create a new record, the TypeID field is not null, it is already filled with 0.
    1) Clear the Default Value property of TypeID in the table.
    2) If you want to correct existing records, remove the 0 values from TypeID.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IsNull (Access 2000)

    Thank you !

Posting Permissions

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