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 Rhinorhino 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
Joined
Jun 9, 2008
Messages
57
Location
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
=format(longnumber,"000000")
 
Upvote 0 Downvote
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 Question
I want to save keystrokes leading up to error
Replies
4
Views
349
TheresAlwaysAWay
TheresAlwaysAWay
rubbernilly
  • Locked
  • Question Question
Cycle Property = Current Page skips TabStop 0
Replies
5
Views
490
combo
combo
jaaret
  • Locked
  • Question Question
Return "No Records" if Count([Field])=0
Replies
1
Views
208
jaaret
jaaret
Webkins
  • Locked
  • Question Question
How to validate Access 2010 form text box, integers only (0-9)
Replies
3
Views
289
missinglinq
missinglinq
papadilbert
  • Locked
  • Question Question
Query does not return rows where a related ID field = 0
Replies
4
Views
141
papadilbert
papadilbert

Part and Inventory Search

Sponsor

Back
Top