I have a grid that has 3 groups and columns in each of the groups. The GroupHeader line = 3.
I'm creating a caption for each header using something like this:
"Line1" & vbcrlf & "Line2 & vbcrlf & "Line3"
On the screen it looks fine. 3 separate lines;however, when I export to Excel it creates one long line:
Line1Line2Line3
How can I make the exported version look like the on screen version, i.e., 3 separate lines? Thanks -jim
Hi Jim,
I tried this out and it works fine for me. I see all three lines of text in the Excel file.
Can you post a small sample project demonstrating this behavior so I can check it out? You can attach a file to your post under the Options tab.