Results 1 to 6 of 6
  1. #1
    nader is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2008
    Posts
    6

    Question How make MsA accept 0 number in the beginning?

    I'm using MsA2007 but I saved the file to MsA2003.
    I tried to insert in the record of field number starting by 0 example:098786
    but it didn't accept or more clear it show it like this 98786. How can I make it accept 0 number in the beginning .

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It will need to be a Text (string) field, not a numeric field.

  3. #3
    nader is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2008
    Posts
    6
    Thank you!!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome. Do you want to use the Thread Tools at the top of the thread and mark this thread as Solved?

  5. #5
    nader is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2008
    Posts
    6
    Quote Originally Posted by RuralGuy View Post
    You're welcome. Do you want to use the Thread Tools at the top of the thread and mark this thread as Solved?
    marked this thread as Solved

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thank You.

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

Similar Threads

  1. Replies: 6
    Last Post: 06-09-2011, 03:41 PM
  2. Make auto number
    By sanos_a in forum Access
    Replies: 9
    Last Post: 10-07-2010, 06:14 AM
  3. Beginning Design Help
    By GenericHbomb in forum Database Design
    Replies: 30
    Last Post: 08-20-2010, 09:41 AM
  4. How to make a field accept No spaces
    By jhjarvie in forum Forms
    Replies: 4
    Last Post: 09-26-2009, 04:10 PM
  5. Replies: 5
    Last Post: 02-08-2006, 08:42 PM

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