Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Rule? (Office XP)

    I can't remember how I did it before, but I don't remember how to make access allow a zero at the front of a number. Any helps is greatly appreciated!
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access Rule? (Office XP)

    If you are using a number field, you can set the Format property of the field (or of a control on a form or report bound to it) to, for example, 00000 if you always want to display 5 digits. This will not affect the way the number is stored, only how it is displayed.
    If you are using a text field, you can use the Input Mask property to enforce a certain format.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Rule? (Office XP)

    It's the simplest things I seem to forget...though I don't know much more than that :/ Thanks Hans
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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