Access 2010 or 2013 Database Search

User avatar
hlewton
PlatinumLounger
Posts: 3788
Joined: 24 Oct 2010, 23:39
Location: Canton, Ohio USA

Access 2010 or 2013 Database Search

Post by hlewton »

If I want to search for the whole word "at" in an Access database is there a way to do it and not find all other words containing the letters at?

Thanks
Regards,
hlewton

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Access 2010 or 2013 Database Search

Post by HansV »

You might search for the string " at " (without the surrounding quotes).
Best wishes,
Hans

User avatar
hlewton
PlatinumLounger
Posts: 3788
Joined: 24 Oct 2010, 23:39
Location: Canton, Ohio USA

Re: Access 2010 or 2013 Database Search

Post by hlewton »

Yep a space before at and a space after worked. Thanks
Regards,
hlewton

User avatar
hlewton
PlatinumLounger
Posts: 3788
Joined: 24 Oct 2010, 23:39
Location: Canton, Ohio USA

Re: Access 2010 or 2013 Database Search

Post by hlewton »

Rather than start a new thread I'll ask this here. Is there a way to get real time spell check in Access like in Word? I think it is no but thought I'd ask.
Regards,
hlewton

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Access 2010 or 2013 Database Search

Post by HansV »

You mean that misspelled words will be underlined as you type? That is not available in Access (nor in Excel). You have to invoke spell checking manually, by clicking Spelling in the Records group of the Home tab of the ribbon, or by pressing F7.
Best wishes,
Hans

User avatar
hlewton
PlatinumLounger
Posts: 3788
Joined: 24 Oct 2010, 23:39
Location: Canton, Ohio USA

Re: Access 2010 or 2013 Database Search

Post by hlewton »

That is what I thought. Thanks
Regards,
hlewton