Line Returns

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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
 
Back
Top