Line Returns

[Steve]

I have a form with 28 fields; 4 are comboboxes, 23 are textboxes and 1 is a memo
field. Some fields may be left blank when entering a new record. After one or
more new records are created, the TransferText method is used to create a pipe
delimited text file from the new record(s) in the table. A line return in any
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 best
time and place to check.

Thanks!

Steve

 

[Ron Weiner]

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