| re: Line Returns
If you are using access 2000 or greater you can use the VBA Replace()
function for each field.
Replace (strToTest, vbCrLf," " ) will remove all of the CrLf's from the
string to test and replace them with a single space.
Where to do it is up to you. Since the CrLf's have no impact on access
Text or Memo fields I would probably remove them in the query I used for
TransferText.
Ron W
"Steve" <spam@nospam.spam> wrote in message
news:NVcHb.11276$IM3.5503@newsread3.news.atl.earth link.net...[color=blue]
> I have a form with 28 fields; 4 are comboboxes, 23 are textboxes and 1 is[/color]
a memo[color=blue]
> field. Some fields may be left blank when entering a new record. After one[/color]
or[color=blue]
> more new records are created, the TransferText method is used to create a[/color]
pipe[color=blue]
> delimited text file from the new record(s) in the table. A line return in[/color]
any[color=blue]
> field causes a problem for the final use of the text file. I need
> recommendations on how to check for line returns and when and where is the[/color]
best[color=blue]
> time and place to check.
>
> Thanks!
>
> Steve
>
>[/color]
| 
