Enter New Line Text Field

[Donya]

I need to code a ctrl enter into a text field. I have bullet points in the
field and need hard enter applied before each bullet point.

 

[KARL DEWEY]

Try CTRL-ENTER to add a line in a field.

 

[Donya]

I need to "build" my statement to include "CTRL-ENTER" in the expression code.

 

[KARL DEWEY]

Where are you trying to 'build' the statement?

 

[Donya]

in a query

Where are you trying to 'build' the statement?

 

[KARL DEWEY]

If you are wanting to do an update query the you need to determine the Ascii
code of the character you are using for a bullet. First determine it's
location in the field.
Then use a calculated field --
Ascii Value: Asc(Right(Left([YourField], X), 1))
X is the location in the field.
Then for update use --
Replace([YourField], Chr(Z), Chr(Z) & Chr(13) & Chr(10))
Z is the Ascii code determined above. The Replace inserts a carriage return
and a line feed for every bullet.

 

[Donya]

THANKS!! This sounds PERFECT!!

If you are wanting to do an update query the you need to determine the Ascii
code of the character you are using for a bullet. First determine it's
location in the field.
Then use a calculated field --
Ascii Value: Asc(Right(Left([YourField], X), 1))
X is the location in the field.
Then for update use --
Replace([YourField], Chr(Z), Chr(Z) & Chr(13) & Chr(10))
Z is the Ascii code determined above. The Replace inserts a carriage return
and a line feed for every bullet.
--
KARL DEWEY
Build a little - Test a little

in a query