Add a new line to a string expression

#1 (**permalink**) 28-Jul-2006, 08:42 AM

I'm trying to combine two textbox together and I want the result to be place
under each other not on the same line.

*

#2 (**permalink**) 28-Jul-2006, 08:42 AM

"anunes" wrote in message
news:40E21426-7AB9-425B-ABB4-590504CA2F3F@microsoft.com
> I'm trying to combine two textbox together and I want the result to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14048-add-a-new-line-string-expression.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14048
> be place under each other not on the same line.

NewText = [Text1] & vbCrLf & [Text2]

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

#3 (**permalink**) 28-Jul-2006, 08:42 AM

Create a new text box and set the control source as

[Field1]&[Field2]

Or - with a space
[Field1]&" "&[Field2]

Change the field names to whatever they are.

--
Wayne
Manchester, England.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14048

"anunes" wrote:

> I'm trying to combine two textbox together and I want the result to be place
> under each other not on the same line.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14048