MS originally stated that Memo fields only searched the first 255 characters. At some point they changed that but did not change the documentation as far as I can tell.
From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Cathy Jupp
Sent: Thursday, May 31, 2012 1:29 PM
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] Memo fields in Access 2010
No, nobody ever did, so thank you for taking the trouble to reply.
In that case I can't imagine where I got the idea from that they weren't searchable. I appreciate the help.
Regards
Cathy
From: AccessDevelopers@yahoogroups.com [AccessDevelopers@yahoogroups.com] on behalf of Duane Hookom [duanehookom@hotmail.com]
Sent: 31 May 2012 17:56
To: access developers
Subject: RE: [AccessDevelopers] Memo fields in Access 2010
Cathy,
I don't know if anyone ever replied to this. Memo fields are searchable in earlier versions. For instance, this query works as expected:
SELECT [1stTable].*
FROM 1stTable
WHERE MemoField Like "*Your Search Here*";
Duane Hookom
MS Access MVP
To: AccessDevelopers@yahoogroups.com
From: cathy.jupp@stoneham.plc.uk
Date: Thu, 3 May 2012 04:48:28 +0000
Subject: [AccessDevelopers] Memo fields in Access 2010
Can anyone tell me please, are memo fields searchable in Access 2010? I know they weren't on earlier versions.
Many thanks
Cathy Jupp
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar