Duplicate and edit record question

[bangsmic]

Upon duplicating a record, each field of the record has all of the text highlighted. If I begin typing to edit the data it all gets erased. If I click on the field first, the text is de-selected and I can edit away. How do I eliminate this extra step of having to click on the field?

 

[PaulBricker]

There must be something that causes all the fields in the Record to become highlighted. Do you have code running to check for duplicates? The Default Keyboard behavior on entering a field is Select Entire Field and when all the fields are selected (highlighted), they get deleted when you start typing something new. There is a Method for Fields that allows you to select where to place the cursor when you enter a field which is the same thing as click the mouse in that field. You can do it for the entire Database under Tools....Options....Keyboard...Behavior Entering Field or you can use the SelStart Property in VBA to determine where the Cursor will be placed when you enter a field.
This might be a starting point for you.

Paul

 

[bangsmic]

Thanks, this took care of the the problem of having to click in each field to de-select the text (except the first field), a definite improvement. I find it odd though that if any text is highlighted in any field and I print the associated report, none of the data prints. Just the Pre-formatted portions of the report itself.

Learn something new every day with this program!!