Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change field format in table with existing data (2000)

    I have a database in which I list social security numbers using an SSN input mask. There are already numerous records in the database. I need to only start collecting the last 4 digits of the SSN. Is there a way to change the field format to have default 0's in the first 5 digits and prompt you to enter just the last 4? If this can be done, will it automatically change the SSN's in records already in the database?

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

    Re: Change field format in table with existing data (2000)

    A format is only a way of displaying data, it doesn't change the values actually stored. But it will affect the display for all records, both existing and new records.
    You can change the inpit mask; this won't affect existing records either.
    If you are sure you will never need the first digits any more, I would run an update query once to replace all SSN's by their last four characters Right([SSN],4).

  3. #3
    New Lounger
    Join Date
    Nov 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change field format in table with existing data (2000)

    Thanks Hans! I ran the update query and then just modified my design of the field in the table and input form to accomodate all new information. You're a lifesaver! <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

    Dana

Posting Permissions

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