Results 1 to 3 of 3
  1. #1
    Diwakarc is offline Novice
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Location
    India
    Posts
    1

    Split a field text strings into different cells in forms.

    Hi All,

    I want to split the text string to its individual letters in forms.

    For Eg :



    1. A field in my table has a person's Name as "Diwakar"
    2. I want to use the name in my form in a split view like "
    D i w a k a r

    Please provide me with an easy implementation method.

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    First of all...why? What is the business need? Why is this needed?

    You see this kind of thing in a printed form...to make sure that a user fills the form out clearly; filling out a form via a keyboard doesn't require this!

    How many 'spaces' are you going to allow? What if the entered name goes beyond this allowance?

    Giving us an idea of why you need this will help us a better idea of how to advise you.

    Linq ;0)>

  3. #3
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    you might want to compare notes with the OP on this thread

    https://www.accessforums.net/forms/f...ask-51630.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Tidy Up/Split Text in One Field
    By JamesBond in forum Queries
    Replies: 8
    Last Post: 04-15-2014, 10:39 AM
  2. Inactive Cells (rows and columns) in Split Form table
    By SyntaxSocialist in forum Forms
    Replies: 3
    Last Post: 04-17-2013, 03:18 PM
  3. Delete Specific Text Strings in a Field
    By JET in forum Queries
    Replies: 5
    Last Post: 08-25-2011, 03:33 PM
  4. split text field
    By Zukster in forum Queries
    Replies: 4
    Last Post: 01-11-2011, 10:01 PM
  5. Split text field into two text fields
    By Grant in forum Access
    Replies: 6
    Last Post: 01-31-2008, 05:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums