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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> New Line in a textbox    
 
   
lukesb
post Apr 28 2009, 09:55 AM
Post#1



Posts: 430
Joined: 6-February 08
From: 01902 ENGLAND


Hi
Is it possible to move onto a new line in a text box..?
e.g.
CODE
=[Name] & ", " & [Surname] & VBCRLF & [Address1] & ", " & [PostCode]

Thanks
Luke
Go to the top of the page
 
fkegley
post Apr 28 2009, 10:10 AM
Post#2


UtterAccess VIP
Posts: 23,740
Joined: 13-January 05
From: Mississippi


Yes, set the Enter Key Behavior property of the text box to New Line in Field.
Go to the top of the page
 
lukesb
post Apr 28 2009, 10:18 AM
Post#3



Posts: 430
Joined: 6-February 08
From: 01902 ENGLAND


Cheers Frank...
ill the syntax I used above work..? the VBCRLF part..?
Luke
Go to the top of the page
 
Alan_G
post Apr 28 2009, 10:40 AM
Post#4


Remembered as Utterly Yorkshire and Forum/Wiki Editor
Posts: 16,533
Joined: 12-January 03
From: Devon UK


Hi
bCrLf wont work directly in the Control Source of a textbox. I think you'd need.........
CODE
=[Name] & ", " & [Surname] & Chr(10) & Chr(13) & [Address1] & ", " & [PostCode]
Go to the top of the page
 
lukesb
post Apr 28 2009, 10:50 AM
Post#5



Posts: 430
Joined: 6-February 08
From: 01902 ENGLAND


Cheers Alan
That are Chr(10) and Chr(13)
Cheers
Luke
Go to the top of the page
 
lukesb
post Apr 28 2009, 10:58 AM
Post#6



Posts: 430
Joined: 6-February 08
From: 01902 ENGLAND


That's not working Alan. Any ideas what I might be doing wrong..?
Go to the top of the page
 
fkegley
post Apr 28 2009, 11:17 AM
Post#7


UtterAccess VIP
Posts: 23,740
Joined: 13-January 05
From: Mississippi


Luke, chr(10) and chr(13) are the line feed and carriage return characters. If they are not working, then try reversing them to this:

chr(13) & chr(10)

Edited by: fkegley on Tue Apr 28 12:17:47 EDT 2009.
Go to the top of the page
 
Bob_L
post Apr 29 2009, 01:40 PM
Post#8


Utterly Banned
Posts: 7,038
Joined: 5-December 02



Frank said it -
When using Chr(13) and Chr(10) together you need to put them in that order 13 before 10.
You need to put a carriage return Chr(13) before the line feed Chr(10)
Hope that helps.
Go to the top of the page
 
lukesb
post May 6 2009, 09:03 AM
Post#9



Posts: 430
Joined: 6-February 08
From: 01902 ENGLAND


Spot on guys, thanks for your help...!!!
uke
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd October 2017 - 08:42 AM