Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2004
    Posts
    24

    Unanswered: joining two fields

    hi

    i've got one table, with two fields. I'm going to create a make table with a new field:

    new field: field1 & field2

    but i want the new field to show me the data of field1, then below that, the data of field2 (thus seperated by a press of the enter button).

    I've tried: new field: field1 & chr(13) & field2 , but it doesn't work.

    any ideas?
    thanks!

  2. #2
    Join Date
    Sep 2004
    Posts
    8

    Field Type

    In your new table, what type of field are you using. Text field may not work with a return key. Have you tried a Memo type field?

  3. #3
    Join Date
    Sep 2004
    Posts
    24
    hello,
    thanks for the reply, but i changed the field type into memo, but still doesn't work...

  4. #4
    Join Date
    Sep 2004
    Posts
    8
    Have you tried using field1 & space(10) & field2; this will put 10 spaces between filed 1 and 2. Replace 10 with the number of spaces you want.

  5. #5
    Join Date
    May 2004
    Posts
    65

    try vbCrLf

    I have recently tried to do the same thing on a form with chr(10) & chr(13) and it did not work. I used the following code in vb and it worked.

    newtext = firsttext & vbCrLf & secondtext

    I am not sure whether it will work in a query... but try!

  6. #6
    Join Date
    Sep 2004
    Posts
    24
    hello

    the space command works, but i'd like to have a return in the field, so it comes out nicely on a form. The vb constant is not recognized in a query...

    thanks anyway!

  7. #7
    Join Date
    Oct 2003
    Posts
    706
    Is there a "WordWrap" type property?

    CRLF is, of course, "Chr$(13) & Chr$(10)" if it helps.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  8. #8
    Join Date
    Sep 2004
    Posts
    24
    thanks!

    i used this: field1 & Chr$(13) & Chr$(10) & field2
    and it worked!

Posting Permissions

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