By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Line Returns

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <sp**@nospam.spam> wrote in message
news:NV******************@newsread3.news.atl.earth link.net...
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.