Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access - fill in zeros for SSN import

Status
Not open for further replies.
jaegca

jaegca

Instructor
Dec 5, 2001
20
US
We are importing employee data into Access - the imported SSN does not display the &quot;zeros&quot; that some SSN start with - any way to set the properties of the field to automatically populate SSN that import with <9 numbers to put zeros at the beginning. Thanks so much!
 
Sort by date Sort by votes
Would having the the SSN input mask defined in the field before import take care of this problem?
 
Upvote 0 Downvote
Nope - that didn't work - but I did change the data type from text to number and formatted Nine &quot;0&quot;s and that worked - put a zero in if no digit there.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
401
renigar
renigar
renigar
  • Question
Access VBA Syntax Error
Replies
5
Views
294
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
753
TheresAlwaysAWay
TheresAlwaysAWay
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
960
grnzbra
grnzbra
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
766
OCM
OCM

Part and Inventory Search

Sponsor

Back
Top