Results 1 to 3 of 3
  1. #1
    dgriffin is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    7

    Combo Box Zero Fill

    I have a form with a combo box that zero fills for customer number. The problem is when they key in 26 it finds customer 260001 instead of just taking the 26 and zero filling so that its 000026. I have CUSTNO_COMBO = Right("000000" & CUSTNO_COMBO, 6) in the after update. Is there a way I can get this to happen?

    Thanks


    Darlene

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    What method are you using for the search? Show full code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    I have CUSTNO_COMBO = Right("000000" & CUSTNO_COMBO, 6) in the after update.
    And what exactly do you think this does?

    Are you trying to do something like
    CustNumJustified = Format(CustNo,"000000") ???

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

Similar Threads

  1. Combo Box Won't Fill
    By dccjr in forum Programming
    Replies: 1
    Last Post: 02-20-2013, 10:26 PM
  2. Replies: 5
    Last Post: 11-09-2012, 04:18 PM
  3. combo box to fill listbox
    By accesshelpme in forum Access
    Replies: 4
    Last Post: 05-19-2012, 04:10 PM
  4. Creating a auto fill from a combo box
    By Trina76 in forum Forms
    Replies: 4
    Last Post: 02-07-2012, 02:43 PM
  5. Using a combo box to fill in other fields
    By mccluein in forum Access
    Replies: 1
    Last Post: 03-14-2011, 05:40 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