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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Leading Zeros

Status
Not open for further replies.
fiber0pti

fiber0pti

ISP
Nov 22, 2000
96
US
I've been reading a lot of the posts about leading zeros and I can't find one that works the way I want it.
I have part #'s. I want to have a field that displays 001,002,etc... It always takes out the leading zeros. How do I make access not do this?
 
Sort by date Sort by votes
Hi FiberOpti! It'll have to be a text field. :) Gord
ghubbell@total.net
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
I want to save keystrokes leading up to error 1
Replies
4
Views
94
TheresAlwaysAWay
TheresAlwaysAWay
Kativs
  • Locked
  • Question
Leading zeros in MS Access form needed 2
2
Replies
24
Views
104
Kativs
Kativs
Secretgeek
  • Locked
  • Question
Leading Zeros Required
Replies
2
Views
29
Secretgeek
Secretgeek
cwindoma
  • Locked
  • Question
Access 2007 - Concatenating Leading Zeros, and Storing an 11-Digit Num
Replies
8
Views
89
cwindoma
cwindoma
PL01
  • Locked
  • Question
Dropped leading 0 1
Replies
3
Views
27
RoyVidar
RoyVidar

Part and Inventory Search

Sponsor

Back
Top