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!

Dropped leading 0 1

Status
Not open for further replies.
PL01

PL01

Technical User
Jun 9, 2008
57
US
Is it possible to format Access so the leading '0' doesn't drop away from a long number? i.e. so 107 will read as 0107 when the report prints.
 
Sort by date Sort by votes
Something like this?
Code: 
format(yourfield,"0000")


Randy
 
Upvote 0 Downvote
Is this a report question? If so, you should consider the report forum ( forum703 ).

In the report, select the textbox in question, and in it's format property (properties dialog), enter 0000 (four zero's).

Roy-Vidar
 
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
rubbernilly
  • Locked
  • Question
Cycle Property = Current Page skips TabStop 0
Replies
5
Views
145
combo
combo
jaaret
  • Locked
  • Question
Return "No Records" if Count([Field])=0
Replies
1
Views
99
jaaret
jaaret
Webkins
  • Locked
  • Question
How to validate Access 2010 form text box, integers only (0-9) 1
Replies
3
Views
87
missinglinq
missinglinq
papadilbert
  • Locked
  • Question
Query does not return rows where a related ID field = 0 1
Replies
4
Views
49
papadilbert
papadilbert

Part and Inventory Search

Sponsor

Back
Top