Results 1 to 2 of 2
Thread: Dymo Printer labels in Access
2010-10-08, 09:02 #1
- Join Date
- Jan 2008
- Thanked 0 Times in 0 Posts
This is not a problem - not anymore, at least, but I thought the solution should be shared. I've been struggling for some time to get Dymo labels to print correctly. They're rotated 90 degrees, and the only posts I could find showed no way of resolving the issue. I corrected the problem by creating a label with only one text box. In that text box, I concatenated all the values I needed on the label, and then set the property of the entire text box to vertical (on the "Other" tab of the text box properties). Here's what's in my text box:
[FirstName] & " " & [LastName] & chr(13) & chr(10) & [Address1] & chr(13) & chr(10) & [Address2] & chr(13) & chr(10) & [City] & ", " & [Province] & " " & [Postal]
Who knew that learning the ASCII codes for Carriage Return (chr13) and Line Feed (chr10) would actually come in handy at some point?
A simple, elegant solution to anyone looking to rotate several lines of text within any report in Access.
2010-10-08, 19:28 #2
- Join Date
- Dec 2009
- Rochdale, UK
- Thanked 161 Times in 139 Posts
Just a thought, wouldn't using vbCrLf instead of chr(13) & chr(10) give the same result?