Access 2003: Carriage return and line feed in text field

[Alan T]

I have a table with text column.
How do I enter carriage return and line feed after a text?
eg.
This is the line <--- add carriage return and then line feed character.

I would like to do inside the Access2003 by opening the table.

 

[Allen Browne]

Ctrl+Enter gives a CrLf.

On a form, you could also set the Enter Key Behavior property of the text
box.

 

[Alan T]

Hi,

Sorry, I mean I would like to run the MSAccess 2003, open the database, open
the table, select the text column. Then type in the text eg. "First part",
then enter the carriage return and line feed characters at the end of the
"First part". After that I continue entering other text say like "Second
part", then repeat adding the carriage return and line feed.

I tried you suggestion, it seems has first line, then second line and so on.

 

[John W. Vinson]

Hi,

Sorry, I mean I would like to run the MSAccess 2003, open the database, open
the table, select the text column. Then type in the text eg. "First part",
then enter the carriage return and line feed characters at the end of the
"First part". After that I continue entering other text say like "Second
part", then repeat adding the carriage return and line feed.

I tried you suggestion, it seems has first line, then second line and so on.

Read what Allen suggested.

He gives you two options:

1. Type "First part", then hold down the Ctrl key and press the Enter key,
then type "Second part".

2. Do your data entry using a Form (Forms are designed for that purpose,
tables are not); in the Properties of the textbox bound to this field find the
"Enter Key Behavior" property and set it to "New line in field".

Then type

First line

press the Enter key

and then type

Second line

and see what you get.


John W. Vinson [MVP]

 

[Allen Browne]

If you want to enter multiple lines into *one* field in *one* record of a
table, just use Ctrl+Enter. You will need to increase the row height to be
able to see the lines.

If that's not what you need, I have not understood you.

 

[Alan T]

Hi, I want to append Carriage Return character and Line Feed character at
the end of the line.
Does Ctrl+Enter append these 2 "characters"?

 

[John W. Vinson]

Hi, I want to append Carriage Return character and Line Feed character at
the end of the line.
Does Ctrl+Enter append these 2 "characters"?

Yes. Did you try it???

John W. Vinson [MVP]