Existing Data Disappears on Click

[scopelenz]

Existing Data Disappears when attempting to Edit

Hello all,

I have a rather simple issue. When I open up my form filled with previously entered data, it looks fine, but when I click on it and attempt to append new information in the textbox, the previously entered data disappears and is replaced by the data that I was attempting to add.

Now, if I click undo, the data comes back, and is completely editable. I can add or edit the data without the risk of the data disappearing and having the type all over again.

The issue seems to be that when any key is detected in a textbox with already filled data, the data disappears and is replaced immediately with the new text. Is there a way to prevent this from happening so that my users will not have to press undo or even type their information all over again?

 

[RainLover]

the previously entered data disappears and is replaced by the data that I was attempting to add.

How can Data appear that you have not entered?

 

[scopelenz]

Sorry for being confusing.

Imagine a form with multiple fields, one of which is called "Customer Details".

There is a log in page for different users at the start of the database.

One of the users has keyed in some information in "Customer Details", and another user - with a separate account - logs in and wishes to edit the information keyed in under "Customer Details". He sets the cursor in the textbox, but on any key press, the previously entered information is wiped out. He has to either undo the action or key in the information again to prevent data loss.

Any idea what is happening here? This baffles me a lot, and I would appreciate a workaround to eliminate the need to reenter information or consistently press 'undo' if any edits are necessary to existing data.

 

[RainLover]

It is hard to understand what is going on.

Does the Text Box dissapear along with the text that was just entered.

Also is the undo button the one on the Ribbon.

 

[scopelenz]

It is hard to understand what is going on.

Does the Text Box dissapear along with the text that was just entered.

Also is the undo button the one on the Ribbon.

No. The textbox remains fine. I instructed my users to use either Ctrl + Z or the Undo on the ribbon.

Allow me to explain again.

Some data has been entered in a Form called, Customer Info. The data is captured in text boxes as either text strings or memos.

When the data is viewed again through the SAME FORM, the data displays well in the form. However, when a user attempts to edit the existing data in the textboxes, the data disappears on any key. Pressing undo (whichever way) will remedy the situation, though.

What I am asking, is if there is a way to prevent existing data that is viewed in my forms to disappear when I attempt to edit them. I am wondering if this is due to a setting which I used or an Access issue.

 

[RainLover]

I see. It is just the Text where you are entering an alteration that this happens, not the whole Record.

This is in the Access Options, Under the Edit/Find Tab.

 

[scopelenz]

I see. It is just the Text where you are entering an alteration that this happens, not the whole Record.

This is in the Access Options, Under the Edit/Find Tab.

Yup. Sorry that I wasn't clear earlier - only the specific text box which I was trying to edit will have its data wiped, and only for that record as well.

Where's the options again? I am using Access 2007. Which specific one should I change?

 

[RainLover]

I don't know Access 2007 very well.

It is in the Menu Bar of 2003.

Suggest you search Access Help.

 

[Pat Hartman]

The default enter behavior is to select the entire contents of a text box when you tab into it. With the existing text selected, any characters you type will replace the existing contrnts. If you use the mouse to click into a control, the insertion point will be whereever you clicked and the surrounding text will not be selected. Double-clicking in a field will select a word. Click and drag will select whatever you specifically choose.

The attached picture shows the available settings for this behavior. The picture is from A2010 but the settings are the same in all versions. You just have to find them. Look under Options.

 

[scopelenz]

The default enter behavior is to select the entire contents of a text box when you tab into it. With the existing text selected, any characters you type will replace the existing contrnts. If you use the mouse to click into a control, the insertion point will be whereever you clicked and the surrounding text will not be selected. Double-clicking in a field will select a word. Click and drag will select whatever you specifically choose.

The attached picture shows the available settings for this behavior. The picture is from A2010 but the settings are the same in all versions. You just have to find them. Look under Options.

Hi, thanks for pointing this out to me through a screenshot.

I changed the settings accordingly, but it does not change the behaviour of my form fields whichever option I select under 'Behaviour entering field'. When the field is selected for editing, the text in the field disappears whichever key I press inside that field.

Does this mean that there're other options which I should change as well?

Thanks.

 

[Pat Hartman]

You have two threads going on this topic. Please write a note in the other to refer to this one.

Did you close Access and re-open it? Generally property settings don't change unless you close and reopen the database.