[AccessD] interesting problem with double lines stored in singlefield

Michael Maddison michael at ddisolutions.com.au
Thu Jun 8 22:27:00 CDT 2006


 Hi Susan,

In EM I have to arrow down in the field to see the data.
QA shows all the data on 1 line.
If you are looking at a textbox in Access try setting multiline property
maybe???

cheers

Michael M

DDI Solutions Pty Ltd
michael at ddisolutions.com.au
Bus: 0260400620
Mob: 0412620497 
www.ddisolutions.com.au
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, 9 June 2006 12:08 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] interesting problem with double lines stored in
singlefield

You can enter two lines in a single field, and often that's convenient.
For instance, instead of requiring an Address2 field for those room
numbers and so on you'd enter them in the same field: 
 
100 First Street
<return>
Room 100
 
But these out of sight and forgotten lines cause problems when
concatenating. 
 
Run the following expression against the Northwind Employees table:
 
FullAddress: [Address] & ", " & [City] & " " & [PostalCode]
 
Three of the records return just the Address value. Those three Address
fields contain more than one line of data. 
 
I've never run into this before. I'm wondering how to work around it --
besides not storing multiple lines in the same field to begin with. 
 
Susan H. 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list