Data Disappearing When Editing the Field

[RMajere]

I am using and Access 2000 database front end with SQL Server 2000.
When I start to edit data in a text field on a form (the form is bound
to the table) it disappears. Does anyone have any idea what may be
causing this? I have verified this behavior with different tables and
different forms. It does not matter if the field on the form is a text
or combo box. Also, it does not matter what data type the field is on
the SQL server. It happens on varchar, nvarchar, ntext, etc. I
suspect that it has something to do with the forms. I have edited data
directly on one of the affected tables, and the data did not disappear.
Is there a property setting for the forms that I am missing? I have
spent a lot of time researching this issue and not be able to find a
solution. Thanks in advance for the help.

 

[Sylvain Lafontaine]

Maybe you forgot to set Autocorrect to Off ?

 

[Guy]

This maybe a slightly left of field response, but have you set the form cycle
property to current record.
If you have it set to all records it will automatically cycle to the next
record when you tab out of the "last" field in the tab order.

Alternatively is the form filtered? If so you will need to specify a resync
command, although, normally you get the message "record has been added to the
database, but can not be displayed" type error if this is the case.

Hope this helps.

Guy

 

[RMajere]

Guy, Sylvain -

Thanks for the help, but neither suggestion is working. I set the
autocorrect property to false on a text box and then tried editing the
data, and it still disappeared. I also tried setting the cycle
property to current record and same thing. The form is not filtered.

When the data disappears, if you hit Ctrl + Z (Undo), the data
reappears again and then lets you edit as normal. Is there a property
setting that I might be missing?

 

[Sylvain Lafontaine]

Maybe a video driver problem. Try disabling all video accelarations to see
if something changes.

 

[Sylvain Lafontaine]

Forget about my last post; here another suggestion: is the text highlighted
like it has been selected when you start typing?

 

[RMajere]

The text was not highlighted. If I click anywhere in the field and
then try editing the data disappears. I have verified this behavior
with multiple PCs and user accounts.

 

[Sylvain Lafontaine]

Is this an ADP project file or a MDB file with linked tables?

 

[RMajere]

It is an ADP project.

 

[Sylvain Lafontaine]

What kind of data source are you using for the forms: the name of the table,
Select * from Table, a stored procedure?

 

[RMajere]

I am using the name of the table as a datasource on one of the forms.
One of the other forms uses a view of a different table. Both are
exhibiting the same behavior.

I was doing some testing, and if I create a new form based on the same
data sources mentioned above it does not show the problem. Is it
possible that the form could be corrupt? I have a hard time believing
so since 20+ forms (and different datasources) are all doing the same
thing. However, when a new form is created I do not seem to have this
problem. That is why I am thinking that maybe there is a property
setting that I am missing. I would prefer not to re-create 20+ forms
only as a last resort.

 

[Sylvain Lafontaine]

Did you try importing everything into a blank new ADP file?

 

[Sylvain Lafontaine]

With some copy&paste, it's not to long to import all controls of a form unto
another form (don't forget to put a control at location (0,0) to keep your
alignment) or you can also try to copy the whole form using Copy&Paste or
the Save as... command.

 

[RMajere]

I tried that, and I still have the data disappearing issue. It only
seems to work if it is a form created from scratch.

 

[Sylvain Lafontaine]

ADP 2000 is very buggy, maybe you should upgrade to A2003 if possible.

Did you try Copying&Pasting all controls of a form into a new empty form?

 

[Malcolm Cook]

maybe one of your colleagues, as a joke, turned on conditional formatting on the field to display white on white when the field has
focus...

just guessing here....

heh heh?

--Malcolm

 

[RMajere]

Sylvain,

The copying and pasting feature works on a new blank form, and I will
upgrade to A2003 since that is possible.
Thanks for all your help.

 

[RMajere]

I think I know what you talking about. One of the forms is based upon
a view and if the user changes the data, then a message pops up
something like "Record was added, but..." If you check the data table
you can see the data was updated.

In this case, the record itself is not diappearing. It is the data in
the text field. The rest of the record remains intact. I have
compared the property settings from working/non-working forms and they
match.

 

[Sylvain Lafontaine]

Does the text disappear visually: the cursor stay in place or if the cursor
goes to the beginning of the box?

 

[RMajere]

The text disappears visually and the cursor goes the beginning of the
text box.