By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Report Shows the "Return" Character

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"~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.
Nov 12 '05 #2

P: n/a
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.<<
Nov 12 '05 #3

P: n/a
"~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
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.