Results 1 to 4 of 4
  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419

    Create break in Access field

    For example if I have a few sentences in a field.

    This is sentence A. This is sentence B. This is sentence C.



    I want to print this out into word or power point with a break as in.

    This is sentence A.
    This is sentence B.
    This is sentence C.

    New line between each sentence. How to do this ?

  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,518
    In what context? In VBA you can use vbCrLf

    VariableName = "This is sentence A." & vbCrLf & "This is sentence B." & vbCrLf & "This is sentence C."
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    Thanks pbaldy.
    But is a field and then it’s a variable and the variable is the store of all three sentence. Maybe I need to carve and separate the sentence into pieces then use your method ?

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Maybe I need to carve and separate the sentence into pieces
    For sure. What separates every portion consistently. A period?
    If you already have it assigned to a variable, you must already have written some code. Why not post what you've tried in order to put more context around the question?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Create a calculation field in Access
    By m.vesali in forum Access
    Replies: 8
    Last Post: 11-06-2018, 11:17 AM
  2. Replies: 5
    Last Post: 01-24-2018, 10:45 AM
  3. Replies: 6
    Last Post: 06-26-2015, 09:18 PM
  4. Break field out into separate table (aka normalize).
    By mountainclimber in forum Database Design
    Replies: 4
    Last Post: 06-19-2015, 01:13 PM
  5. How to create an Iif field in Access 2013
    By buick1910 in forum Access
    Replies: 9
    Last Post: 10-27-2013, 05:59 PM

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