Solved

Access 2007 = Forms

Posted on 2014-11-24
9
255 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 58

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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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 58
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

717 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