Hi, from my VBA code I am creating a dynamic control Label and Text Box. I
need to force a "line feed" or "carriage return" in in the middle of the
text. I tried adding a Chr(10) and Chr(13) value to the string but this did
not work. For example,

Dim foo As String
foo = " some text "
foo = foo + Chr (13) ' ASCII Carriage Return Char
foo = foo + " some text"
Me.TextBox.TEXT = foo

This code does not work. Can someone provide a solution to this problem,

Thanks,
--
Eddie Eytchison

"Eddie's Bakery and Cafe'" <(E-Mail Removed)> wrote in message
news:77A5E588-BD2D-453F-8431-(E-Mail Removed)...
> Hi, from my VBA code I am creating a dynamic control Label and Text Box.
> I
> need to force a "line feed" or "carriage return" in in the middle of the
> text. I tried adding a Chr(10) and Chr(13) value to the string but this
> did
> not work. For example,
>
> Dim foo As String
> foo = " some text "
> foo = foo + Chr (13) ' ASCII Carriage Return Char
> foo = foo + " some text"
> Me.TextBox.TEXT = foo
>
> This code does not work. Can someone provide a solution to this problem,
>
> Thanks,
> --
> Eddie Eytchison

Try this:

foo = foo & Chr (13) ' ASCII Carriage Return Char

Hi Jacco, I tried using the "&" but this did not work. Do you have another
suggestion?

Thanks for your help

"Jacco" wrote:

>
> "Eddie's Bakery and Cafe'" <(E-Mail Removed)> wrote in message
> news:77A5E588-BD2D-453F-8431-(E-Mail Removed)...
> > Hi, from my VBA code I am creating a dynamic control Label and Text Box.
> > I
> > need to force a "line feed" or "carriage return" in in the middle of the
> > text. I tried adding a Chr(10) and Chr(13) value to the string but this
> > did
> > not work. For example,
> >
> > Dim foo As String
> > foo = " some text "
> > foo = foo + Chr (13) ' ASCII Carriage Return Char
> > foo = foo + " some text"
> > Me.TextBox.TEXT = foo
> >
> > This code does not work. Can someone provide a solution to this problem,
> >
> > Thanks,
> > --
> > Eddie Eytchison
>
> Try this:
>
> foo = foo & Chr (13) ' ASCII Carriage Return Char
>
>
>
>
>

Try:
foo=foo & vbCrLf

"Eddie's Bakery and Cafe'" <(E-Mail Removed)> wrote in message
news:48A14085-7273-494E-AF97-(E-Mail Removed)...
> Hi Jacco, I tried using the "&" but this did not work. Do you have
> another
> suggestion?
>
> Thanks for your help
>
> "Jacco" wrote:
>
>>
>> "Eddie's Bakery and Cafe'" <(E-Mail Removed)> wrote in message
>> news:77A5E588-BD2D-453F-8431-(E-Mail Removed)...
>> > Hi, from my VBA code I am creating a dynamic control Label and Text
>> > Box.
>> > I
>> > need to force a "line feed" or "carriage return" in in the middle of
>> > the
>> > text. I tried adding a Chr(10) and Chr(13) value to the string but
>> > this
>> > did
>> > not work. For example,
>> >
>> > Dim foo As String
>> > foo = " some text "
>> > foo = foo + Chr (13) ' ASCII Carriage Return Char
>> > foo = foo + " some text"
>> > Me.TextBox.TEXT = foo
>> >
>> > This code does not work. Can someone provide a solution to this
>> > problem,
>> >
>> > Thanks,
>> > --
>> > Eddie Eytchison
>>
>> Try this:
>>
>> foo = foo & Chr (13) ' ASCII Carriage Return Char
>>
>>
>>
>>
>>

On Sun, 27 Feb 2005 22:19:03 -0800, Eddie's Bakery and Cafe' wrote:

> Hi, from my VBA code I am creating a dynamic control Label and Text Box. I
> need to force a "line feed" or "carriage return" in in the middle of the
> text. I tried adding a Chr(10) and Chr(13) value to the string but this did
> not work. For example,
>
> Dim foo As String
> foo = " some text "
> foo = foo + Chr (13) ' ASCII Carriage Return Char
> foo = foo + " some text"
> Me.TextBox.TEXT = foo
>
> This code does not work. Can someone provide a solution to this problem,
>
> Thanks,

In Access you must use the chr(13) & chr(10) combination
IN THAT ORDER.

= "Line 1." & chr(13) & chr(10) & "Line 2."

In VBA you can also use vbCrLf or vbNewLine.

[SomeControl] = "Line 1." & vbCrLf & "Line 2."

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

=?Utf-8?B?RWRkaWUncyBCYWtlcnkgYW5kIENhZmUn?= <(E-Mail Removed)>
wrote in news:77A5E588-BD2D-453F-8431-(E-Mail Removed):

> Me.TextBox.TEXT = foo

You cannot access the Text property of a control (unless it has the focus).
Try

Me!textbox.Value = "foo" & vbCrLf & "foo again"


HTH


Tim F

Actually try foo = foo + Chr(13) + Chr(10)


Jacco wrote:
> "Eddie's Bakery and Cafe'" <(E-Mail Removed)> wrote in message
> news:77A5E588-BD2D-453F-8431-(E-Mail Removed)...
>
>>Hi, from my VBA code I am creating a dynamic control Label and Text Box.
>>I
>>need to force a "line feed" or "carriage return" in in the middle of the
>>text. I tried adding a Chr(10) and Chr(13) value to the string but this
>>did
>>not work. For example,
>>
>> Dim foo As String
>> foo = " some text "
>> foo = foo + Chr (13) ' ASCII Carriage Return Char
>> foo = foo + " some text"
>> Me.TextBox.TEXT = foo
>>
>>This code does not work. Can someone provide a solution to this problem,
>>
>>Thanks,
>>--
>>Eddie Eytchison
>
>
> Try this:
>
> foo = foo & Chr (13) ' ASCII Carriage Return Char
>
>
>
>