How2 Format a datasheet cell to have line breaks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple Access 2003 subform, as a datasheet view, I simply want to
display some of the details within the same cell but with line breaks (shift
Enter).

Each detail has numerous details but there are several address fields that
I'd like to stack on top of one another, in the same cell

HouseName
Street
City

Tried the form source in the SQL... but ran out of ideas at:

jim: [City] & Chr(13) & [Postcode]

Thank you for any help.
 
bin_leigh said:
I have a simple Access 2003 subform, as a datasheet view, I simply want to
display some of the details within the same cell but with line breaks (shift
Enter).

Each detail has numerous details but there are several address fields that
I'd like to stack on top of one another, in the same cell

HouseName
Street
City

Tried the form source in the SQL... but ran out of ideas at:

jim: [City] & Chr(13) & [Postcode]
Click to expand...


That should be:

jim: [City] & Chr(13) & Chr(10) & [Postcode]
 
You must log in or register to reply here.

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

Similar Threads

Record with multiple lines 1
multiple line breaks on form 1
Need to force 2 lines in cell 3
Text to Columns with Line Breaks. 3
Data Conversion Manual Line Break 3
Problem with line breaks 1
Line break in custom date format? 6
convert soft line breaks to new cell 1

Back
Top