Highlight Field on Click for Editing (F2)

[mktwhse]

I have an Access 97 database that when converted to Access 2007 everything seems to work except for the Send Keys function. I have a sendkeys function on the on-click action in a form that sends F2 which highlights the entire field so that it can be completely overwritten as opposed to the normal behavior of just inserting a cursor for editing. Is there a work around for this?

Thanks,

Rob

[Scott Price]

Good morning, and welcome to the Scripts!

Converting from Access 97 to 2007 isn't a task for the faint of heart :-)

Allen Browne's website here Acesss Tips: Converting to Access 2007 is an excellent resource including links to other very good resources.

That said, I'm not sure about the send-keys function, but I believe I've seen a thread on that somewhere here. Let me take a look and get back to you.

Regards,
Scott

[Scott Price]

This is a link to MS website with a discussion of Access 2007 sandbox mode. Apparently the sandbox mode will restrict the availability of a number of functions, among which is SendKeys. It will result in an error when called from VBA. http://office.microsoft.com/en-us/ac...301901033.aspx

As far as a solution, that depends on your application. One developer's advise is to always develop your applications for the maximum level of security restrictions that will be imposed by Access: in other words don't look for a way to make it work by lessening the restrictions, look for a way to re-design so as to not infringe the security imposed by sandbox mode.

That said, again depending on your application requirements, you could explore resetting the sandbox mode to a lower level to see if that will allow the SendKeys to work.

Regards,
Scott

[mktwhse]

Thanks for the reply....,well let's forget about security and sandbox rules. What if I was writing a brand spanking new DB in Access 2007? How do I accomplish the following. I have a Order Entry Form with certain text box fields that when clicked I want to completely highlight, so a single keystroke will erase the the existing data enabling to input new data. It is what hitting F2 will do, but I don't want the user to have to hit F2. As opposed to do the default of clicking the text box field and the insert cursor blinking at the point of click. Maybe a "Select all" function? How do I program this under the "OnCLick" function?

Thanks,

Rob

[Scott Price]

Thanks for the reply....,well let's forget about security and sandbox rules. What if I was writing a brand spanking new DB in Access 2007? How do I accomplish the following. I have a Order Entry Form with certain text box fields that when clicked I want to completely highlight, so a single keystroke will erase the the existing data enabling to input new data. It is what hitting F2 will do, but I don't want the user to have to hit F2. As opposed to do the default of clicking the text box field and the insert cursor blinking at the point of click. Maybe a "Select all" function? How do I program this under the "OnCLick" function?

Thanks,

Rob

This code works fine in the On Click event of a text box in Access 2003. Give it a try:

    Me!Text1.SelStart = 0
    Me!Text1.SelLength = Len(Me!Text1.Text)

You'll need to rename Text1 to the name of your text box.

Regards,
Scott

[NeoPa]

Alternatively try :
Tools / Options / Keyboard / Behavior entering field ==> Select entire field.
This is a per PC (installation of Access) approach mind you, but may be easiest. It may even be possible to force using code within a database but I don't know the code if it is.

[mktwhse]

Thanks for the responses, I'll the try the SelLength code tomorrow. I appreciate the other response regarding the setting per pc, I knew about that, but I don't want the behavior on all fields.

Thanks,

Rob

[Randoz]

This works great for text box, but shouldn't it work for a combo box as well. I can't seem to get it to work on a combo box.

Randy

[missinglinq]

Why would you want to select the text in a combobox?

Linq ;0)>

[NeoPa]

This works great for text box, but shouldn't it work for a combo box as well. I can't seem to get it to work on a combo box.

Randy

It shouldn't, no.
It would make little sense for it to work that way in a ComboBox.

[Randoz]

I have a combo box set up to either select from existing text or add new text.