CTRL+A To select all in field not every record.

[cluts]

Hello There,

You will have to go easy on me as I am fairly new to Access.

When entering/editing data on a form, when CTRL+A (Select All) is pressed it selects all the records in the table linked to the form. From what I can gather this is because the shortcut is set in access. Is there any way to make the CTRL+A keyboard shortcut to select all of the data in the selected field not every record in the table.

I am using access 2010.

I hope that all makes sense.

Many Thanks in Advance for your help.

Paul

 

[Isskint]

Would it not be easier to just click the Record Selector (the grey box to the left side of each record)? Failing that you need to set a key down event for the Detail section and check for CTRL + A and put some VBA in to select current record.

 

[cluts]

Sorry, it looks like i didn't explain that properly.

What I meant was that if you were typing into a field, e.g Customer Name, and I wanted to select all the text in that field, pressing CTRL+A will select every record in the table that the form is linked to. But I would like it to select all the text in the field that I am typing in.

Thanks

Paul

 

[cookiegary01]

Press HOME. Then press SHIFT + END. All you text is selected.