Results 1 to 3 of 3
  1. #1
    scott k is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    1

    need help displaying zeros


    I have a record counter of 4 digits. as new records are entered the count increases by one. I need to show the record number with zeros to the left of the counting digits. ie record 50 needs to read 0050 . thak yuo

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Not much info. Since you posted in a general part of the forum, maybe you just need to put 0000 in the format property of what i assume is a number field in a table?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Join Date
    Apr 2017
    Posts
    1,673
    In case you need to save record number with real 0's at left, not simply formatting the field or control, the field must be text one. The formula to calculate the value saved to field will be
    Code:
    =RIGHT("0000" & CStr(RecordNumber), 4)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Need zeros so that it will add right!!!
    By Daisy509th in forum Queries
    Replies: 3
    Last Post: 03-15-2018, 07:22 AM
  2. Problem with zeros
    By jtm013 in forum Queries
    Replies: 19
    Last Post: 05-15-2015, 10:51 AM
  3. Do not add leading zeros
    By phifer2088 in forum Access
    Replies: 5
    Last Post: 03-02-2015, 10:05 AM
  4. Hiding Zeros
    By Alex Motilal in forum Reports
    Replies: 2
    Last Post: 08-06-2010, 08:28 AM
  5. Getting rid of zeros
    By ceb39 in forum Reports
    Replies: 26
    Last Post: 05-31-2009, 12:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums