Results 1 to 3 of 3

Need macro for to replace "00R" to Inserting the numbers 1, 2 ...etc as a normal text

  1. #1
    ganesang is offline Novice
    Windows XP Access 2016
    Join Date
    Jul 2018

    Post Need macro for to replace "00R" to Inserting the numbers 1, 2 ...etc as a normal text


    I wanted to change the text "00R" to 001,002,003... etc in the entire document. Also "00R" is styled as "total points".

    So i have to change all "00R" to normal text sequence numbers as mentioned above.

    If any options to ask message box as "enter your star number" and if enter the number as "1" then replace from that entered number.

    Please let me know if not clear. I am just trying to find out using wildcard but not able to found.

    Please let me know if anything not clear.

    Ganesan. G
    Last edited by ganesang; 07-30-2018 at 05:42 AM. Reason: incorrect spelling

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    1. what document? an access field? an access report?

    2. once you ask for the start#,(here assume 1)
    it replaces the 1st 00R with 01R
    then 2nd 00R with 02R?

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Suggest instead of popup input box, have a textbox on form for input of start value. Then on report:

    1. in textbox in DetailSection set ControlSource to =1 and RunningSum to OverAll

    2. in another textbox calculate: =Format([Text1] + Forms!formname!textbox - 1, "000\R")
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

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

Similar Threads

  1. Replies: 2
    Last Post: 09-21-2017, 05:36 PM
  2. Replies: 3
    Last Post: 04-20-2016, 01:50 PM
  3. Update Query, Inserting Variable Number of "0"
    By bigchicagobob in forum Queries
    Replies: 4
    Last Post: 03-25-2014, 06:33 AM
  4. inserting "dashes" into text field
    By desimoreno in forum Access
    Replies: 2
    Last Post: 05-23-2013, 10:44 AM
  5. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 07:00 AM

Posting Permissions

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