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]
 
Back
Top