Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Changing memo field

Discussion in 'Information Technology' started by DIH, Jul 28, 2006.

  1. DIH

    DIH
    Expand Collapse
    Guest

    I have a form called frmInputBath. In this form is a bound textbox
    called txtProblems. The field property is set to Memo. I would like to
    enter one line of text and press enter to have it drop to a new line.
    When all the lines of text are entered, I have a report that prints this
    text out. I want to have the report condense the individual lines of
    text into a paragraph form (with a carriage return 'box' character)
    showing where the user pressed the enter key (otherwise the report size
    will be very large). In other words, I would like it to work the same as
    when importing text from an excel spreadsheet into Access.

    e.g.

    FIRST PROBLEM CODE GOES ON THIS LINE
    SECOND PROBLEM WOULD GO HERE
    THIRD CODE PROBLEM GOES HERE
    DONE

    I want it to look like this in the report:

    FIRST PROBLEM CODE GOES ON THIS LINE[]SECOND PROBLEM WOULD GO
    HERE[]THIRD CODE PROBLEM GOES HERE[]DONE


    Any help would be greatly appreciated!

    Dave
     
  2. Loading...

    Similar Threads Forum Date
    S Asia Thinking about the big move: The Sikh way of life changing in Khyber-Pakhtunkhwa Breaking News Mar 22, 2014
    Opinion Haanji's Quick Takes on a Changing World (September 23, 2013) Breaking News Sep 22, 2013
    Changing my last name to Kaur... Questions and Answers May 15, 2013
    Life-changing Inspirational Stories Mar 31, 2013
    USA Sikhism and the Changing Electoral Demographic Breaking News Mar 8, 2013

  3. carletta Bell

    carletta Bell
    Expand Collapse
    Guest

    "DIH" <nospam@dot.com> wrote in message
    news:GL%jg.26602$X02.3811@trnddc02...
    >I have a form called frmInputBath. In this form is a bound textbox called
    >txtProblems. The field property is set to Memo. I would like to enter one
    >line of text and press enter to have it drop to a new line. When all the
    >lines of text are entered, I have a report that prints this text out. I
    >want to have the report condense the individual lines of text into a
    >paragraph form (with a carriage return 'box' character) showing where the
    >user pressed the enter key (otherwise the report size will be very large).
    >In other words, I would like it to work the same as when importing text
    >from an excel spreadsheet into Access.
    >
    > e.g.
    >
    > FIRST PROBLEM CODE GOES ON THIS LINE
    > SECOND PROBLEM WOULD GO HERE
    > THIRD CODE PROBLEM GOES HERE
    > DONE
    >
    > I want it to look like this in the report:
    >
    > FIRST PROBLEM CODE GOES ON THIS LINE[]SECOND PROBLEM WOULD GO HERE[]THIRD
    > CODE PROBLEM GOES HERE[]DONE
    >
    >
    > Any help would be greatly appreciated!
    >
    > Dave
     
  4. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Dave,

    Try the following for a memo field named "MyMemoField", in a table named
    "Table1". Make the appropriate substitutions in your case:

    SELECT Table1.MyMemoField,
    Replace([MyMemoField],Chr(13)+Chr(10),"[]") AS CondensedMemoField
    FROM Table1;

    This seems to work okay in my limited testing, as long as you are not using
    rich text in the memo field.


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "DIH" wrote:

    > I have a form called frmInputBath. In this form is a bound textbox
    > called txtProblems. The field property is set to Memo. I would like to
    > enter one line of text and press enter to have it drop to a new line.
    > When all the lines of text are entered, I have a report that prints this
    > text out. I want to have the report condense the individual lines of
    > text into a paragraph form (with a carriage return 'box' character)
    > showing where the user pressed the enter key (otherwise the report size
    > will be very large). In other words, I would like it to work the same as
    > when importing text from an excel spreadsheet into Access.
    >
    > e.g.
    >
    > FIRST PROBLEM CODE GOES ON THIS LINE
    > SECOND PROBLEM WOULD GO HERE
    > THIRD CODE PROBLEM GOES HERE
    > DONE
    >
    > I want it to look like this in the report:
    >
    > FIRST PROBLEM CODE GOES ON THIS LINE[]SECOND PROBLEM WOULD GO
    > HERE[]THIRD CODE PROBLEM GOES HERE[]DONE
    >
    >
    > Any help would be greatly appreciated!
    >
    > Dave
    >
     

Share This Page