SSN field too small

[Guest]

I have been working on a project for class to create a database. I have a
been able to add 2 people to the databas as the project went along. Now I am
at the end, and need to add one final person to the database and it will not
take it!! The field giving me problems is the SSN field which is masked and
has worked before. The error is as follows:

The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.

I have re worked the mask for the SSN field to no avail. Any suggestions?

 

[Brian]

I have been working on a project for class to create a database. I have a
been able to add 2 people to the databas as the project went along. Now I am
at the end, and need to add one final person to the database and it will not
take it!! The field giving me problems is the SSN field which is masked and
has worked before. The error is as follows:

The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.

I have re worked the mask for the SSN field to no avail. Any suggestions?

Make the field bigger, maybe?

 

[Arvin Meyer]

My first warning is that you really need to avoid using SSNs in a database.
Unless you have 100% security, and 100% honest and careful employees, you
run the risk of exposing the person to identity fraud, and yourself to a
lawsuit. Besides, because of fraud and error, SSNs are a poor identifier and
that makes them practically useless as a key.

Secondly, your Input Mask probably is including the dashes in the saved
field, which adds 2 characters to the field size. Change your field size to
11 characters to make it work.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Mike Schlosser]

You say it was working before.
Are you sure it is this field and not another, like a long last name.
Compare the size of all of your fields to the sizes of the data being
entered.
Increase as needed.
Your teacher may try to break the program.
If your are using text fields to get the entries, set the max size of each
to the sizes of the fields.

Mike Schlosser

 

[John Vinson]

I have been working on a project for class to create a database. I have a
been able to add 2 people to the databas as the project went along. Now I am
at the end, and need to add one final person to the database and it will not
take it!! The field giving me problems is the SSN field which is masked and
has worked before. The error is as follows:

The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.

I have re worked the mask for the SSN field to no avail. Any suggestions?

Make sure it's not a LOOKUP field. If you try to store a 9-digit SSN
in a 4-byte Long Integer ID field, you'll get this error; and if the
SSN is a Lookup field, the 4-byte number is what is actually stored in
the table, with that fact being concealed from your view by the Lookup
misfeature.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps]