Results 1 to 4 of 4
  1. #1
    Goodge12 is offline Novice
    Windows XP Access 97
    Join Date
    Sep 2008
    Posts
    25

    Hard Returns v. Squares

    Hi All-

    New to this site... please help. Trying to create a short-term solution and having an issue with this....



    Have two memo fields (Existing Comments, Add New Comments)... want people to be able to Add a New Comment to the Existing Comments Section (which is read-only- don't want people erasing old messages).

    Right now, using an update query for the field "Existing Comments" that looks something like this (don't laugh):

    [Idea List]![Existing Comments] & "
    " & Date() & [Idea List]![Add New Comments]

    My return is the Existing Comments, a little square, the date, then the new comments. Instead of the square, I want a hard return or two. Any suggestions?

    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
    Try:
    [Idea List]![Existing Comments] & vbCrLf & Date() & [Idea List]![Add New Comments]

  3. #3
    Goodge12 is offline Novice
    Windows XP Access 97
    Join Date
    Sep 2008
    Posts
    25

    Talking Found it!

    Thanks, I tried that one, but it didn't work for me for some reason. However, I was able to insert this into the string, and it worked!

    Chr(13) & Chr(10)

  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
    Glad you got it working and thanks for posting back with your success.

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

Similar Threads

  1. Access 2003 Date() Function returns "#Name?"
    By smartel@soprema.ca in forum Programming
    Replies: 5
    Last Post: 01-18-2012, 05:52 AM
  2. Replies: 1
    Last Post: 09-05-2008, 12:07 PM
  3. Simple but hard question
    By andymok in forum Reports
    Replies: 1
    Last Post: 09-20-2007, 09:19 AM

Tags for this Thread

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