Results 1 to 4 of 4
  1. #1
    Divardo is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    12

    Aligning a string vertically

    I have a date stored which I would like to output on a report in a verticle manner. Would there be a way this could be done in a function through access, I am quite a beginner to this. I have tried through the properties on textboxes in the reports section of Access 2007 but can't seem to get the desired effect.



    Below is a example of the dates as they are at the moment and how I would like them to be displayed...


    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Are these date from different records? If so, I don't think you can get Access to do that.

  3. #3
    Divardo is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    12
    Yes there are in different records. Would it be possible to place them all together in one and then add a carriage between each one? If so how?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    This link should help you put all of the values together but I don't know what will happen when you try and display then vertically. vbCrLf is the constant for a NewLine.

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. # added to string with Dlookup
    By normever in forum Programming
    Replies: 1
    Last Post: 02-27-2009, 10:52 AM
  3. concatenate string using loop
    By nengster in forum Programming
    Replies: 0
    Last Post: 02-23-2009, 08:05 PM
  4. Convert string to date
    By ~SwAmPdOnKeY~ in forum Queries
    Replies: 4
    Last Post: 09-11-2008, 07:19 PM
  5. Replies: 0
    Last Post: 12-05-2005, 04:09 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