One string above the other?

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

Guest

I have two strings per cell in an Excel spreadsheet that I'm formatting into
a report. They are date ranges, for instance "1-7" and "1-21". Even though
they're in the same cell, I'd like one to appear above the other in the
report.

Is that possible?

Thanks,
Ellen
 
Is this a linked table from Excel or an Access table? What is the actual
value stored in the field?
 
Hi Duane,
It's in a linked Excel table. The actual value is "1-7 1-20" or "1-21 2-3".
I've tried adding spaces in between the "dates" to force them appear above
each other in Access.

Thanks in advance for your help. (I'm also grateful for the help you've
given me in the past.)
 
You can narrow the text box and allow it to grow. You can also replace the
space with Chr(13) & Chr(10)
=Replace([YourCell]," ", Chr(13) & Chr(10))
 
Back
Top