Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006
    Posts
    3

    Question Unanswered: Separate field into single characters?

    I have a field that needs to be broken down into individual characters on just one form. Is this possible in Access, and if so any ideas how to accomplish it? Thanks in advance.

  2. #2
    Join Date
    Dec 2006
    Posts
    3
    I figured it out. I have a form that gets filled out for each admission with the little bubbles that get filled in by hand. I wanted to computerize it but was having trouble figuring out how to get things like date of birth and such to work. I used a text box set to =Mid([DOB],1,1) to get the first digit, and then did an option group 0-9. I then set the value of the Frame to equal the value of the text box. It's a bit of work up front, but will make things so much easier in the long run.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What happens if they're born in october or later? I would look into the day() month() and year() functions...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Dec 2006
    Posts
    3
    This is for ID numbers, not dates. Although the same principle would work for dates, as all dates are in the same format (at least in my database): 09.06.2006.

Posting Permissions

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