One string above the other?

[EllenM]

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

 

[Duane Hookom]

Is this a linked table from Excel or an Access table? What is the actual
value stored in the field?

 

[EllenM]

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.)

 

[Duane Hookom]

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))