Question about the fine dialog box

[itmasterw]

Question about the find dialog box

Hi,

I just upgraded and application from MS Access 2003 - 2010. In the old application they had the focus set to an textbox on the form that haled and ID field. Which I set up the same in the new application so when the form loads the box has the focus. In the old version if you do a control F the fine dialog box opens and it will actually say Look In: field name and have the name of that field in it.
While it is pointing there, because if I just type and ID in it will find the info for that ID. The users want it to say it like the old one does.
Dose anyone know how to do this?

Attach is an image of what the old one does

Thank you

 

[CJ_London]

there must be a setting somewhere - using ctrl-F still works in 2010 (well it does for me)

 

[itmasterw]

Yes, that is what I have been trying to find. Any ideas where I can find this??

 

[CJ_London]

Sorry, no idea. As I said, it works fine in my 2010.

All I can suggest is to check this happens with every control or just this one. If the latter it will be something to do with your control - whether it be a property setting or some code (perhaps in the form open, load or current events) that runs that changes it.

It may be that the control does not have the focus when you hit ctrl F for example

As Access has moved up the versions, it has become less and less tolerant of 'sloppy' code i.e. something that was not trapped before, is being trapped now, causing unexpected results.

You could try googling for an answer - something like 'access disable find dialog box' or 'access enable find dialog box' or 'access ctrl-F', etc

One other thought - have you tried right clicking on the control and selecting the filter option (different from find) as a method of working

 

[The_Doc_Man]

Not sure where, but from the Ribbon, try:

File >> Options >> Current Database and then scroll through those settings. There are a lot of them including some that by default turn off certain options as a security setting.

 

[itmasterw]

Hi,
I am sorry but I think maybe I was not clear, based on you responses. It is working. If for example, I put the cursor in the box and hit ctl F the fine box opens. If I put a value in there it will find it.
The problem is if you notice the screen shot of the old one I attached it will so the name of the field that it is in and in the now one it will not; it still works, but it shows Current location instead of the name of the field.
I tried goggling it and found nothing.
Thank you

 

[CJ_London]

mine says 'current field', not 'current location'

And if that is the problem, I don't think there is anything you can do about it - but take a look in Options per Doc's suggestion, there may be something there.

PS - having # in a field name is a bad idea - it confuses SQL where # is used to identify date strings.

 

[tzenm0god]

The Find and Replace dialog box provides an option called the Search for Fields as Formatted check box. As you progress through the steps in this topic, you will see that Access sometimes selects the check box automatically; Vcetests.com .So sometimes, you must select or clear the checkbox yourself. Proper use of the check box can help ensure that the search operation is successful.