Results 1 to 4 of 4
  1. #1
    Yodo is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    12

    How to restrict data input.

    I have several columns that should have "+" or "-". Users correct these columns and sometimes they put double "++" or "--". How to lock column to store only "-" or "+" and nothing else?

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 10 Access 2016
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    Set the length of the field in the table design to 1.

  3. #3
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    you could also do some validation in VBA for the textbox where this data is entered.

  4. #4
    Yodo is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    12
    Thank you! The first approach is the simplest one, so I stick to it. Users will not confuse plus or minus with a letter or a number.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-05-2015, 02:21 PM
  2. Data Type to input data number
    By TioAdjie in forum Access
    Replies: 5
    Last Post: 02-17-2014, 11:21 AM
  3. Replies: 3
    Last Post: 08-07-2013, 06:03 AM
  4. Restrict data entry to preset list
    By chrisfl in forum Forms
    Replies: 2
    Last Post: 06-28-2013, 01:16 PM
  5. Using Validation rules to restrict certain types of data entry.
    By Long Tom Coffin in forum Database Design
    Replies: 3
    Last Post: 07-23-2012, 10:38 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums