How do I insert a line break in a text box?

G

Guest

I am trying to format a text box with two different fields from a query. I
want to show the "Subject" and then the "Description". My problem is that I
want the description to start on the next line, but I don't know how to
insert a line break in the expression builder. This is what I have so far in
the control source property of my text box.

=[Subject] & [Description]

Thanks for your help!
 
A

Allen Browne

Add a carriage return and line feed:
=[Subject] & Chr(13) & Chr(10) & [Description]
 
R

Rick B

Did you even attempt to look for this answer before posting? This is asked
ALLLLL the time in these newgroups.

Please SEARCH before posting a new thread.
 
B

BruceM

True enough, but not everybody knows about such things as Google groups. I
learned about searching groups through this group. May I suggest that while
your point is valid, pointing somebody toward a way of searching would be
most helpful?

Rick B said:
Did you even attempt to look for this answer before posting? This is
asked
ALLLLL the time in these newgroups.

Please SEARCH before posting a new thread.

--
Rick B



meowbaby said:
I am trying to format a text box with two different fields from a query. I
want to show the "Subject" and then the "Description". My problem is
that I
want the description to start on the next line, but I don't know how to
insert a line break in the expression builder. This is what I have so
far in
the control source property of my text box.

=[Subject] & [Description]

Thanks for your help!
 
R

Rick B

Bruce:

Good point. Google works best for searches, but the users can also search
right there in the same screen where they went to post the message.

I will, as you suggest, include verbiage on how to search in google in the
future, though.

Have a good one!

--
Rick B



BruceM said:
True enough, but not everybody knows about such things as Google groups. I
learned about searching groups through this group. May I suggest that while
your point is valid, pointing somebody toward a way of searching would be
most helpful?

Rick B said:
Did you even attempt to look for this answer before posting? This is
asked
ALLLLL the time in these newgroups.

Please SEARCH before posting a new thread.

--
Rick B



meowbaby said:
I am trying to format a text box with two different fields from a
query.
I
want to show the "Subject" and then the "Description". My problem is
that I
want the description to start on the next line, but I don't know how to
insert a line break in the expression builder. This is what I have so
far in
the control source property of my text box.

=[Subject] & [Description]

Thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top