Results 1 to 2 of 2
  1. #1
    dsheets05 is offline Novice
    Windows XP Access 2000
    Join Date
    Oct 2010
    Posts
    5

    Easy Format Questions


    I need value x to be formated in a way that it is allways two numbers rather it be 04 or 12.... Cant get it to work, any advice? See code below

    dim path1 as string
    dim valuex as string
    valuex = me.assyid.value
    if valuex >= 10 then
    valuex = value x
    else
    valuex = "0" + valuex

    path1 = "J:\Engineering\FAST Houston CAD Dwgs\MODEL AND DRAWINGS\" + AssyIDvalue + "\" + AssyIDvalue + "-" valuex

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Leading zeros are only available in a string and
    Format([YourNumber],"00")
    will achieve this.

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

Similar Threads

  1. Easy question
    By Danzig in forum Access
    Replies: 11
    Last Post: 10-28-2010, 06:48 PM
  2. I know this has to be easy...
    By MelindaP in forum Access
    Replies: 7
    Last Post: 08-20-2010, 02:15 PM
  3. Probably missing something easy
    By z1efuller1 in forum Database Design
    Replies: 5
    Last Post: 11-12-2009, 11:18 AM
  4. Easy Custom Calculation?
    By rjk1080 in forum Queries
    Replies: 6
    Last Post: 07-12-2009, 11:42 AM
  5. databasing CDs, sounds easy right?
    By RAGEFEAR in forum Access
    Replies: 8
    Last Post: 06-02-2009, 04:15 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