Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Microsoft Access

  • 17-01-2012 8:18pm
    #1
    Closed Accounts Posts: 1,419 ✭✭✭


    1st question - when you're designing a table in design view how can you set the field to force the user to input a specific number of digits? For example, a PPS number has to have seven digits and a letter - nothing else could be a PPS number so how can I set up the field to accept this and only this kind of input?

    2nd question - indices/indexes - why? Just, why?


Comments

  • Closed Accounts Posts: 17,208 ✭✭✭✭aidan_walsh


    Don't use Access to answer your first query, but
    2nd question - indices/indexes - why? Just, why?
    Speed with large numbers of records.


  • Closed Accounts Posts: 4,012 ✭✭✭kincsem


    In Field Properties there is a Input Mask property.
    0 ... Digit
    9 ... Digit or space
    # ... Digit or space
    L ... Letter (A-Z, entry required)
    ? ... Letter (A-Z, entry optional)
    a ... Letter (A-Z, entry optional)
    & ... Any character or a space (entry required)
    C ... Any character or a space (entry optional)
    < ... Causes all characters that follow to be converted to lowercase
    > ... Causes all characters that follow to be converted to uppercase

    This is from an old book on Access (1994) so things may have changed. I don't have Access so can't check.

    e.g. "Acct No. "0000
    Data entered 3271
    Data displayed Acct No. 3271


Advertisement