chr(13) & chr(10) not working in my report

[RoosterD]

Hello all, I just started working on our companies access database 2003. We're moving to office 2010.

When printing a purchase order we have a print preview button that displays a report. The code for the "ship to" address works fine in 2003:

=[Companies.CompanyName] & Chr(13) & Chr(10) & [Companies.Address1] & Chr(13) & Chr(10) & [Companies.City] & ", " & [Companies.Region] & " " & [Companies.PostalCode] & Chr(13) & Chr(10) & "Phone: " & [Companies.Phone1] & Chr(13) & Chr(10) & "Fax: " & [Companies.Fax]

However, in 2010 I get this very informative #Type! message. I've tried using vbCrLf and vbNewLine to no avail. Basically it thinks vbCrLf is a variable and adds [vbCrLf] to it; I even tried <BR>... . Then when I go into report view it asks for a value for the parameter.

Any help is greatly appreciated! I've been at this for a while testing different things.

Dave in Sacto

[June7]

Does it work if you reverse the codes: Chr(10) & Chr(13)? Seems I encountered that, just can't remember which way I reversed. Don't have 2010 here (it's at home) but just tested in 2007 and this reversal fails. Can't imagine 2010 would be different. Can't see anything wrong with that expression. Try a simpler expression in another textbox, like "Test" & Chr(13) & Chr(10) & "test". Does it still fail?

You could just use separate textboxes for each piece of data instead of the concatenation into one.

[RoosterD]

Does it work if you reverse the codes: Chr(10) & Chr(13)? Seems I encountered that, just can't remember which way I reversed. Don't have 2010 here (it's at home) but just tested in 2007 and this reversal fails. Can't imagine 2010 would be different. Can't see anything wrong with that expression. Try a simpler expression in another textbox, like "Test" & Chr(13) & Chr(10) & "test". Does it still fail?

You could just use separate textboxes for each piece of data instead of the concatenation into one.

I was thinking the same thing. I tried separate text boxes and found that it worked fine except for longer names. So either it cuts off the last part of the name (fine by me, but not others) or set can grow at which point the subsequent boxes over lap the rest of the page. I appreciate the help. I'll try the reverse, but I seem to remember trying that. Can't hurt to try it again. Thank you

[June7]

Why can't you make the boxes wide enough to display the longest values?

[boblarson]

It is Chr(13) & Chr(10) (the larger one always comes before the smaller in this case - the reason is the Carriage Return must come before the Line Feed and it is logical if you think about what those meant to a printer).

What happens if you use this instead:
=[CompanyName] & Chr(13) & Chr(10) & [Address1] & Chr(13) & Chr(10) & [City] & ", " & [Region] & " " & [PostalCode] & Chr(13) & Chr(10) & "Phone: " & [Phone1] & Chr(13) & Chr(10) & "Fax: " & [Fax]

without the table references.

[RuralGuy]

I've also had success preceeding the sequence with a space " " so you end up with & " " & vbCrLf.