Line break within excel cell via code not working

[htdenver]

Im trying to insert a simple line break via VBA from an access report. Report looks fine but when I export to Excel the cell shows a | istead of putting a line break in. Code to use was simple as follows.

Dcity = Dcity & Chr(13)

MERIDIAN - Showing up as this where Meridian is the city and the line break shows up as a character -

 

[PHV]

You may try this:
Dcity = Dcity & Chr(10)
Or this:
Dcity = Dcity & Chr(13) & Chr(10)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[htdenver]

I tried that, did not work either. Thanks for the help though.

 

[macropod]

Hi htdenver,

In Excel, an 'unprocessed' line break should look like a small box in the cell. To get the line break to 'work, you might need to change the cell's alignment, to turn wrapping on.

Other than that, try using vbCr (or perhaps vbCrLf) instead of Chr(10).

Cheers