New line in field

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mo (m.a.joomun_at_qmul.ac.uk)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 11:21:59 +0100

I have just inherited a db and now need to export data from this db into a
fixed-width text file.

The problem I'm having is with an address field. On the form where these
addresses were entered, 'New Line in Field' has been selected for the 'Enter
key behaviour' option. This allows users to use the return key to
effectively add a new line in a text box for each line of the address. Only
some of the addresses in the table have been entered with 'new lines' so to
speak.

This causes a particular problem when exporting In my text file, each time
there is a record where the address field has been input using this option,
it is being interpreted as a new record.

Is there a way to format the address field to remove this behaviour
entirely, perhaps in a query?

Thnaks for any help.

Mo