Re-formatting Access Table - Don't want column to require characters

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jerrydigital
    New Member
    • Oct 2008
    • 67

    Re-formatting Access Table - Don't want column to require characters

    Hi,

    I created a form for users to register that goes to an Access table. Unfortunately, when the user submits the form and the "Account number" text box is left empty, I get an error that tells me the text box cannot be empty.

    When creating the access table, I entered a valadation rule that said there must be a minimum amount of characters in this box.

    Is there any way to update my table validation requirements? Or, do I need to make a whole new table?

    Thanks for any help, I really appreciate it.

    Jerry
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Simply go back into table Design View and remove the validation requirement.

    Linq ;0)>

    Comment

    • jerrydigital
      New Member
      • Oct 2008
      • 67

      #3
      haha, thanks for your help. some things seem so difficult until you figure them out. I appreciate your post.

      Comment

      Working...