UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Update query - add carriage returns    
 
   
kbrewster
post Sep 5 2008, 09:44 AM
Post #1

UtterAccess VIP
Posts: 4,489
From: NH
I have the following in the update to...

CODE
[tblContacts]![CallBackDetail] & Chr(10) & Chr(13) &
"**FORWARDED AT " & [tblContacts]![ForwardDateTime] & " TO " & [tblDepartments]![Department]
& " BY " & [tblContacts]![ForwardBy] & "**"
& Chr(10) & Chr(13) & "**ADDED ON " & [tblContacts]![ForwardCallBackDateTime]
& " BY " & [tblContacts]![ForwardInitials] & "**"
& Chr(10) & Chr(13) & [tblContacts]![ForwardDetail]


I want to add a carriage return, but instead it creates a square box. How can I add carriage returns to the above statement?

TIA!
Go to the top of the page
 
+
kbrewster
post Sep 5 2008, 09:47 AM
Post #2

UtterAccess VIP
Posts: 4,489
From: NH
**NEVERMIND - I had the (10) and (13) backwards!
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 01:43 AM