Simulate "New line in field" in code????

  • Thread starter Thread starter Paul Baxter
  • Start date Start date
P

Paul Baxter

If I set a text box's "Enter Key Behavior" to "New Line in
Field", hitting the Enter key inserts Chr(10) Chr(13) in
the underlying table to separate the data of the two lines.

But, if I try to duplicate this by running an update query
(or do the same in code in the form's Current event) that
combines two fields' data:
[Field3] = [Field1] & Chr(10) & Chr(13) & [Field2]
when the form looks at that field the textbox lines are
not separated but instead look like:
Field1||Field2

How can I combine 2 or more fields into separate lines in
a third field?

TIA,

Paul
 
The Carriage Return needs to be before the line feed:
[Field3] = [Field1] & Chr(13) & Chr(10) & [Field2]

Easier still:
[Field3] = [Field1] & vbCrLf & [Field2]

BTW, hopefull Field3 is an unbound control in this example? You don't want
to be dirtying the record in the form's Current event.

If it is unbound, and the user does not need to type over it, you could just
set the ControlSource of the text box to:
= [Field1] & Chr(13) & Chr(10) & [Field2]
 
Thanks, Allen. I'll try that.

-----Original Message-----
The Carriage Return needs to be before the line feed:
[Field3] = [Field1] & Chr(13) & Chr(10) & [Field2]

Easier still:
[Field3] = [Field1] & vbCrLf & [Field2]

BTW, hopefull Field3 is an unbound control in this example? You don't want
to be dirtying the record in the form's Current event.

If it is unbound, and the user does not need to type over it, you could just
set the ControlSource of the text box to:
= [Field1] & Chr(13) & Chr(10) & [Field2]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

If I set a text box's "Enter Key Behavior" to "New Line in
Field", hitting the Enter key inserts Chr(10) Chr(13) in
the underlying table to separate the data of the two lines.

But, if I try to duplicate this by running an update query
(or do the same in code in the form's Current event) that
combines two fields' data:
[Field3] = [Field1] & Chr(10) & Chr(13) & [Field2]
when the form looks at that field the textbox lines are
not separated but instead look like:
Field1||Field2

How can I combine 2 or more fields into separate lines in
a third field?

TIA,

Paul
Click to expand...


.
Click to expand...
 
Back
Top