Solved

Access 2007 = Forms

Posted on 2014-11-24
9
252 Views
Last Modified: 2014-11-24
My OS is win 7 prof 64 bit and I use Office 2007.  I have a small and simple database, where I have a Form that displays the data.  whenever I want to do a search, I usually place the cursor in the required field, and then do a control +F, and it brings up a dialog box to enter the search criteria.  But the "Match" criteria defaults fo " Whole Field".  Is there anyway I can change this to "Any part of the field" as the default.
Thank u.
0
Comment
Question by:jegajothy
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 40462299
With the DB open, click file (or the office button) and click "Options" at the bottom.

Select "Client Settings" on the left, then about half way down, you'll find "Default find/replace behavior".  I believe "general search" is what you want.

Jim.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40462302
sorry, but you can't, add more keystrokes after Ctrl F
Alt H, then 'a'
0
 

Author Comment

by:jegajothy
ID: 40462553
in response to Jim Dettman, thank u for your response.  But in my Access 2007, I do not get what u gave. when I click on the Office button, with the db open or Form open, I only see Access Options.  And when I click on this, I see : Popular; current database; datasheet; object designers, etc. etc.
Hope u are using the same Access version as mine.  thank u.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40462572
look in the Advanced options, but still it will not let you change the default setting.
0
 
LVL 22

Accepted Solution

by:
Flyster earned 250 total points
ID: 40462643
In 2007 select Access Options - Advanced. Under Editing, the fourth option is Default find/replace behavior. Select General Search as Jim stated above.

Flyster
0
 
LVL 57
ID: 40462714
Thanks for jumping in Flyster!

I was looking at 2010.   I think of 2010/2007 being one in the same, but there are differences.

@ jegajothy

 That setting is there...little hard to find but it is there.

Jim.
0
 

Author Comment

by:jegajothy
ID: 40463149
Well done to Flyster.  Thank u and well done.
0
 

Author Closing Comment

by:jegajothy
ID: 40463154
thank u it worked.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 40463466
Glad to help. I too have 2007 in a Window 7 Pro 64-bit environment.

@ Jim- I'll have to take a look at my laptop. It has 2010. Thanks.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question