+ Reply to Thread
Results 1 to 5 of 5

How to use the LPAD in access 2007?

  1. #1
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    How to use the LPAD in access 2007?

    Would anyone know how to use this function??? I've seen samples of it but still don't understand it...

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: How to use the LPAD in access 2007?

    Are you talking about a function that adds text onto the left side of a string?
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

  3. #3
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    Re: How to use the LPAD in access 2007?

    Yes, this works too though:

    OBG: Format([OBG_NO],"0000000000")


    If you don't mind I'd like to learn how to do that still...

  4. #4
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: How to use the LPAD in access 2007?

    I know Access 03 doesn't have an LPAD function, but it'd be easy to create one. From what I've read while Googling, it doesn't sound like 07 has it either? Are you sure it does? Maybe you could paste the help page.

  5. #5
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: How to use the LPAD in access 2007?

    This Microsoft Support page contains a tidy description.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1