Text Boxes

Hi

We recently switched from Access 97 to Access 2002 and I have been having
trouble recreating what I used to do in Access 97 with text boxes. In Access
97 I used to be able to press the enter key (hard return) to get a portion of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and all the
text stays on the same line. Using multiple text boxes for each line is not
an option in my situation. Below is an example of what I would do in the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World

What drive me nuts is the text boxes in the reports that were developed in
97 and converted to 2002 still work fine but when I try to create a new text
box in 2002 with text on multiples line it doesn't work!

Can some please give my head a shake and tell me what I am doing wrong here..

Thanking you in advance!!

JT

CTRL+ENTER


"J. Toews" wrote in message
...
Hi

We recently switched from Access 97 to Access 2002 and I have been having
trouble recreating what I used to do in Access 97 with text boxes. In
Access
97 I used to be able to press the enter key (hard return) to get a portion
of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and all
the
text stays on the same line. Using multiple text boxes for each line is
not
an option in my situation. Below is an example of what I would do in the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World

What drive me nuts is the text boxes in the reports that were developed in
97 and converted to 2002 still work fine but when I try to create a new
text
box in 2002 with text on multiples line it doesn't work!

Can some please give my head a shake and tell me what I am doing wrong
here..

Thanking you in advance!!

JT

Sorry that's the first thing I tried and it doesn't work!! It puts that box
character at the point where I select Ctl-Enter and the rest of the text
doesn't move to the next line.. Anybody else got something better..

"Rick B" wrote:

CTRL+ENTER


"J. Toews" wrote in message
...
Hi

We recently switched from Access 97 to Access 2002 and I have been having
trouble recreating what I used to do in Access 97 with text boxes. In
Access
97 I used to be able to press the enter key (hard return) to get a portion
of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and all
the
text stays on the same line. Using multiple text boxes for each line is
not
an option in my situation. Below is an example of what I would do in the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World

What drive me nuts is the text boxes in the reports that were developed in
97 and converted to 2002 still work fine but when I try to create a new
text
box in 2002 with text on multiples line it doesn't work!

Can some please give my head a shake and tell me what I am doing wrong
here..

Thanking you in advance!!

JT

On Wed, 20 Oct 2004 12:07:04 -0700, J. Toews wrote:

Sorry that's the first thing I tried and it doesn't work!! It puts that box
character at the point where I select Ctl-Enter and the rest of the text
doesn't move to the next line.. Anybody else got something better..

"Rick B" wrote:

CTRL+ENTER

"J. Toews" wrote in message
...
Hi

We recently switched from Access 97 to Access 2002 and I have been having
trouble recreating what I used to do in Access 97 with text boxes. In
Access
97 I used to be able to press the enter key (hard return) to get a portion
of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and all
the
text stays on the same line. Using multiple text boxes for each line is
not
an option in my situation. Below is an example of what I would do in the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World

What drive me nuts is the text boxes in the reports that were developed in
97 and converted to 2002 still work fine but when I try to create a new
text
box in 2002 with text on multiples line it doesn't work!

Can some please give my head a shake and tell me what I am doing wrong
here..

Thanking you in advance!!

JT



Set the Enter Key Behavior property to New Line in Field.
It's on the Control's property sheet's Other tab.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Hi Fred,

You don't have that property available on a text box in a report, only on a
form. I am working with reports.

"fredg" wrote:

On Wed, 20 Oct 2004 12:07:04 -0700, J. Toews wrote:

Sorry that's the first thing I tried and it doesn't work!! It puts that box
character at the point where I select Ctl-Enter and the rest of the text
doesn't move to the next line.. Anybody else got something better..

"Rick B" wrote:

CTRL+ENTER

"J. Toews" wrote in message
...
Hi

We recently switched from Access 97 to Access 2002 and I have been having
trouble recreating what I used to do in Access 97 with text boxes. In
Access
97 I used to be able to press the enter key (hard return) to get a portion
of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and all
the
text stays on the same line. Using multiple text boxes for each line is
not
an option in my situation. Below is an example of what I would do in the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World

What drive me nuts is the text boxes in the reports that were developed in
97 and converted to 2002 still work fine but when I try to create a new
text
box in 2002 with text on multiples line it doesn't work!

Can some please give my head a shake and tell me what I am doing wrong
here..

Thanking you in advance!!

JT



Set the Enter Key Behavior property to New Line in Field.
It's on the Control's property sheet's Other tab.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

"J. Toews" wrote in message
...
Hi

We recently switched from Access 97 to Access 2002 and I have been having
trouble recreating what I used to do in Access 97 with text boxes. In
Access
97 I used to be able to press the enter key (hard return) to get a
portion of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and all
the
text stays on the same line. Using multiple text boxes for each line is
not
an option in my situation. Below is an example of what I would do in the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World

What drive me nuts is the text boxes in the reports that were developed
in
97 and converted to 2002 still work fine but when I try to create a new
text
box in 2002 with text on multiples line it doesn't work!

Can some please give my head a shake and tell me what I am doing wrong
here..

Somehow you are dropping a character. Access only recognizes the two
character combination of Chr(13) followed by Chr(10) which are
CarriageReturn and LineFeed respectively. A field that contains only one
or the other will behave as you are seeing with a small box which is what
Access displays any time it encounters a non-printable character.

I have no idea why that would be happening though.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

You can use Chr(13) & Chr(10) between strings to insert a return. Not sure
if that helps you or not.

= [SomeField1] & Chr(13) & Chr(10) & [SomeField2]


Hope that helps,

Rick B


"J. Toews" wrote in message
news
Sorry that's the first thing I tried and it doesn't work!! It puts that
box
character at the point where I select Ctl-Enter and the rest of the text
doesn't move to the next line.. Anybody else got something better..

"Rick B" wrote:

CTRL+ENTER


"J. Toews" wrote in message
...
Hi

We recently switched from Access 97 to Access 2002 and I have been
having
trouble recreating what I used to do in Access 97 with text boxes. In
Access
97 I used to be able to press the enter key (hard return) to get a
portion
of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and
all
the
text stays on the same line. Using multiple text boxes for each line
is
not
an option in my situation. Below is an example of what I would do in
the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World

What drive me nuts is the text boxes in the reports that were
developed in
97 and converted to 2002 still work fine but when I try to create a
new
text
box in 2002 with text on multiples line it doesn't work!

Can some please give my head a shake and tell me what I am doing wrong
here..

Thanking you in advance!!

JT

J. Toews wrote:

We recently switched from Access 97 to Access 2002 and I have been having
trouble recreating what I used to do in Access 97 with text boxes. In Access
97 I used to be able to press the enter key (hard return) to get a portion of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and all the
text stays on the same line. Using multiple text boxes for each line is not
an option in my situation. Below is an example of what I would do in the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World


It doesn't come out that way for me when I type
="Hello{Ctrl+Enter}World"
in the control source property of a text box.

If worse comes to worse, you could also use the less
convenient
="Hello" & Chr(13) & Chr(10) & "World"

OTOH, If you want to display a constant string, why not use
a Label control instead?

--
Marsh
MVP [MS Access]

OTOH, If you want to display a constant string, why not use
a Label control instead?

--
Marsh
MVP [MS Access]


Because I am not displaying a constant string. I have to call functions
from the text boxes to provide me with the proper dates because the reports
produce year over year - month over month comparisons, based on what date
period the user wants to see a report for. You can not call a function from
a label, at least in Access 97 you couldn't, didn't try it with 2002.. So
the column headers have to be set so they can show any date. It saves me
from having to change labels in 30 different reports everytime a user wants
to see a report with different date comparisons becasue they supply the
parameters and my functions set the text box based on their parameters.

eg. in Access 97 my control source on my text boxes would look something
like this.

=SetPrevYear() & " =SetCurrYear() & "
Expenses" Expenses"

which prints as:

2003/04 2004/05
Expenses Expenses

There is always a method to my madness..

Thanks Marshall!! Your method works. I should have know.. I tried using
chr(10) and chr(13) but not at the same time.. But I have to say just
hitting the enter key in Access 97 is a lot less hastle!!.. Must be a new
FEATURE or IMPROVEMENT!!
"Marshall Barton" wrote:

J. Toews wrote:

We recently switched from Access 97 to Access 2002 and I have been having
trouble recreating what I used to do in Access 97 with text boxes. In Access
97 I used to be able to press the enter key (hard return) to get a portion of
text to move to the next line. In Access 2002 it doesn't seem to work
anymore. All I get is a box character where I put the hard return and all the
text stays on the same line. Using multiple text boxes for each line is not
an option in my situation. Below is an example of what I would do in the
expression builder for the text box in Access 97.

eg.

="Hello
World"

would come out as

Hello
World

But in Access 2002 it comes out as

Hello(box character) World


It doesn't come out that way for me when I type
="Hello{Ctrl+Enter}World"
in the control source property of a text box.

If worse comes to worse, you could also use the less
convenient
="Hello" & Chr(13) & Chr(10) & "World"

OTOH, If you want to display a constant string, why not use
a Label control instead?

--
Marsh
MVP [MS Access]