Report Shows the "Return" Character

[~TheIcemanCometh~]

I have a textbox field on a report that shows an Address. The field is
built up in code when the user selects the customer in the following
manner:

ShipAddress = CustomerName & vbCR & CustomerAddress & vbCR & Customer
City (etc.)

This is done and put into the ShipAddress field on another table.
The ShipAddress field is displayed on a report with the character for
the vbCR ("little box"). How can I get around this problem??

Thanks
Bill

[Rick Brandt]

"~TheIcemanCometh~" <bh********@delta-elevator.com> wrote in message
news:8d**************************@posting.google.c om...

I have a textbox field on a report that shows an Address. The field is
built up in code when the user selects the customer in the following
manner:

ShipAddress = CustomerName & vbCR & CustomerAddress & vbCR & Customer
City (etc.)

This is done and put into the ShipAddress field on another table.
The ShipAddress field is displayed on a report with the character for
the vbCR ("little box"). How can I get around this problem??

You need a carriage return AND a line-feed. Use VbCrLf.

[Bruce M. Thompson]

ShipAddress = CustomerName & vbCR & CustomerAddress & vbCR & Customer
City (etc.)

This is done and put into the ShipAddress field on another table.
The ShipAddress field is displayed on a report with the character for
the vbCR ("little box"). How can I get around this problem??

You need to replace the vbCr constant with vbCrLf or vbNewline to get the full
carriage return. Just one question ... why are you storing this value when it
can be generated on-the-fly (as you did to place it into the field)? Is it for
historical reasons?

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

[Fletcher Arnold]

"~TheIcemanCometh~" <bh********@delta-elevator.com> wrote in message
news:8d**************************@posting.google.c om...

I have a textbox field on a report that shows an Address. The field is
built up in code when the user selects the customer in the following
manner:

ShipAddress = CustomerName & vbCR & CustomerAddress & vbCR & Customer
City (etc.)

This is done and put into the ShipAddress field on another table.
The ShipAddress field is displayed on a report with the character for
the vbCR ("little box"). How can I get around this problem??

Thanks
Bill

Try this:

=[CustomerName] & Chr$(13) & Chr$(10) & [CustomerAddress] ...etc

Fletcher