How did my users do this?

[Mike MacSween]

Doing an export to text file thing for the courier company's labels. Which
wants text delimited by | records by CrLf.

Some of the records have a CRLF in one field. Try as I might I can't get one
in from the user interface by typing. I want to make sure that doesn't
happen again. Apart from pasting from another app, is there any other way
they could have got crlf into a field?

Thanks, Mike

[Allen Browne]

Cntl+Enter puts a CrLf into a field.

Or simply pressing Enter if the text's box's EnterKeyBehavior is set to New
Line In Field.

You may be able to use the Replace() function to locate Chr(13) & Chr(10),
and replace with something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mike MacSween" <mi************************@btinternet.com> wrote in message
news:41*********************@news.aaisp.net.uk...

Doing an export to text file thing for the courier company's labels. Which
wants text delimited by | records by CrLf.

Some of the records have a CRLF in one field. Try as I might I can't get
one in from the user interface by typing. I want to make sure that doesn't
happen again. Apart from pasting from another app, is there any other way
they could have got crlf into a field?

Thanks, Mike

[Mike MacSween]

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...

Cntl+Enter puts a CrLf into a field.
Of course, I forgot. I kept trying Shift+Enter, but that's the 'soft new
line' thingy in Word and such like.
Or simply pressing Enter if the text's box's EnterKeyBehavior is set to
New Line In Field.

Enter's always next field, apart from memos.

Mmmm. I'd forgotten about Ctrl+Enter. I don't really want to trap for CRLF
on every field.

Then again, I only found 2 across 9 fields in 4270 records when I just did a
query. It's probably low down the urgency list. Especially if I:

1. Warn the users about it
2. Run my check query once a month.

Thanks, Mike

[Tim Marshall]

Mike MacSween wrote:

Apart from pasting from another app, is there any other way
they could have got crlf into a field?

Ctrl-Enter

It's what I used to do on text boxes for memo or large text fields and
in fact put instructions for users to do so for line breaks in my status
bar text before I discovered the Enter Key Behaviour property.... 8)

--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Duane Phillips]

[Ctrl] + [Enter]

HTH.

~ Duane Phillips.

"Mike MacSween" <mi************************@btinternet.com> wrote in message
news:41*********************@news.aaisp.net.uk...

Doing an export to text file thing for the courier company's labels. Which
wants text delimited by | records by CrLf.

Some of the records have a CRLF in one field. Try as I might I can't get
one in from the user interface by typing. I want to make sure that doesn't
happen again. Apart from pasting from another app, is there any other way
they could have got crlf into a field?

Thanks, Mike

[Trevor Best]

Mike MacSween wrote:

Doing an export to text file thing for the courier company's labels. Which
wants text delimited by | records by CrLf.

Some of the records have a CRLF in one field. Try as I might I can't get one
in from the user interface by typing. I want to make sure that doesn't
happen again. Apart from pasting from another app, is there any other way
they could have got crlf into a field?

I won't mention Ctrl+Enter as it's been mentioned b4.... D'Oh!

When exporting, I use Replace([field],VbCrlf,"\n") then do the reverse
on the import to the next system.

--
This sig left intentionally blank