This may help:
ReplaceNoCase("#accessfield#", "", "#CHR(10)#", "ALL")
-- Sam
-Original Message-
From: David Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 10:32 AM
To: CF-Talk
Subject: Access Memo Field
I know this question has been answered many times before but I can
heh heh...
Other way round ;o)
Replace(AccessField,chr(10),"","ALL")
Stephen
> This may help:
> ReplaceNoCase("#accessfield#", "", "#CHR(10)#", "ALL")
>
> -- Sam
>
> -Original Message-
> From: David Green [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 14, 2003 10:32 AM
> To: CF-
The best way I know of is to use surround it with That will
perserve spaces and line breaks
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 12:26 PM
To: CF-Talk
Subject: Access "Memo" field format
This has probably been asked before, but...
<<< 255 characters.
That's the maximum length of an Access field (except a memo)
++
Kevin Parker
Web Services Consultant
WorkCover Corporation
p: 08 8233 2548
m: 0418 806 166
e: [EMAIL PROTECTED]
w: www.workcover.com
++
-Original Message-
From: Jake McKee [mailto:[EM
4 matches
Mail list logo