Results 1 to 3 of 3
  1. #1
    timpepu is offline Novice
    Windows XP Access 2003
    Join Date
    May 2009
    Posts
    13

    Geting value/text to ready text


    Hi !

    How to set field when getting text from sheet when the input text would be different characters long ?


    Examble


    [Input text/value here from sheet that would be different characters long] , this text is allways the same , [Input another text/value here from sheet that wloud be different character long]

    Br
    Timo

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I'm not really clear on what you're trying to accomplish. Generally you can do this type of thing:

    [Input text/value here from sheet that would be different characters long] & " , this text is allways the same , " & [Input another text/value here from sheet that wloud be different character long]

    Where your inputs got values from a table, recordset, form or whatever.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    timpepu is offline Novice
    Windows XP Access 2003
    Join Date
    May 2009
    Posts
    13
    Quote Originally Posted by pbaldy View Post
    I'm not really clear on what you're trying to accomplish. Generally you can do this type of thing:

    [Input text/value here from sheet that would be different characters long] & " , this text is allways the same , " & [Input another text/value here from sheet that wloud be different character long]

    Where your inputs got values from a table, recordset, form or whatever.
    Hi !

    I got values from a table or query

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

Similar Threads

  1. How to vertically align text inside a text box ?
    By alexcalgary in forum Forms
    Replies: 2
    Last Post: 10-06-2010, 08:44 AM
  2. Import to text - only text value NOT importing
    By Gerry in forum Import/Export Data
    Replies: 10
    Last Post: 03-26-2010, 06:55 AM
  3. Replies: 0
    Last Post: 03-01-2010, 07:42 PM
  4. joining text in text boxes
    By jjwilliams73 in forum Forms
    Replies: 1
    Last Post: 08-26-2008, 02:30 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