Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    13

    Unanswered: Auto Insert Letter

    How can I set up a field that automatically inserts a letter instead of a number?

    I have a form and subform linked by the FamilyMemberID (autonumber). On the subform I need a field that automatically assigns a MemberCode field with a letter. I used tabbed form with a subform on each tab for each member of the family. Each tab is titled FamilyMemberA, FamilyMemberB, FamilyMemberC, etc. Each subform has alot of different information for each family member. In order to keep the family members names hidden on reports I need to give each a field that inserts the corresponding letter from the tab. I could enter the letter in the field manually but I prefer it to automatically fill the field.

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,477
    Provided Answers: 11
    Q what happen after FamilyMemberZ.


    First Idea

    you count the Number of records in the SubForm then

    ThisLetter = CHR(65+CountofSubFrom)

    so when CountofSubFrom = 2

    ThisLetter = "C"
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Jul 2011
    Posts
    13
    Maybe I need to make myself more clear....

    Instead of using the AutoNum for the field "FamilyMemberCodeA" and have a number inserted into the field, I'd like to have a Letter inserted instead. How do I change the number to a letter?

    Thanks!

Posting Permissions

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