Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2004
    Posts
    9

    Unanswered: Text Field question

    I have a primary key that is a text field - field size is 8. The keys will not always be 8 characters long, however. Is there a formatting option I can use to display the empty spaces as "0"?

    For example if the primary key is "A102" can I set it to display "0000A102"?

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    there is format property in table design mode for each field.
    ghozy.

  3. #3
    Join Date
    Jul 2004
    Posts
    9
    Hi ghozy ... Thanks for your reply.

    I know about the Format option in the Table, however, I'm not sure what to enter here to make this happen ... any hints?

    Thanks!

  4. #4
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    oh yeah, sorry, it doesn't let you add 0 to your format. it is only possible for numbers sorry
    ghozy.

  5. #5
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    is your primary key produces automatic or user typed?
    ghozy.

  6. #6
    Join Date
    Jul 2004
    Posts
    9
    The users will type it in.

Posting Permissions

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