Data in an Access 2000 form sometimes disappear?!

[earnold]

Greetings--I was going to search the forums for such key words as form, data, disappear, etc., but the search engine is down.&nbsp;&nbsp;Therefore, this problem is posted to the world...<br><br>I've made a seemingly simple database in Access 2000. There is one table, one query, one form created from the table, and several simple macros. The table has 183 fields, and all fields are included in the form. The form is a startupform, and is what data is entered into. <br><br>The problem is this...If data in certain fields and in certain records is edited or changed, the data disappears in those particular fields in form view. However, this is not consistent with all the fields, and the data remains in the table. This problem persists whether the control source is the table or the query, or whether I create a new form using a wizard.<br><br>The text boxes in the form are not filled (transparent), the text is colored purple (8388736), the text boxes are in front of a scanned picture, and all the properties are set to always displayed and visible. Edits, additions, deletions are allowed in the form, and data entry is set to no. The form's record set type is dynatype.<br><br>All the fields in the table are text fields. They were once numeric fields, but I've changed them properly. The fields are not combo or look-up fields--they are just basic, flat fields. They are all set at the default properties, with field sizes of 50. There are no relationships and no tricky SQL/VBA.<br><br>What is making the fields in form view disappear after entry/tabbing?? <br><br>Sometimes, the PC's system sound beeps when I tab to or click in a certain field in form view and type a text character--and the form acts like it doesn't want to accept any text. Also, when the cursor is successfully able to enter a field containing data to be edited, certain fields turn 'white' and the cursor seems unrestricted, whereas data in other fields remain visible, and the cursor is positioned on or adjacent to the characters.&nbsp;&nbsp;Arrrrrggghhhh.&nbsp;&nbsp;It must be something simple...<br><br>Any assistance/advice would be appreciated.&nbsp;&nbsp;Eric.<br>

 

[DougP]

If you are using a query and that has say 3 tables.<br>Then some value has to be found in all of the tables. Or the query will return nothing.<br>Example:<br>Say you have the following 3 tables:<br>Customers<br>Invoices<br>Parts<br><br>In order to see something in a query between the 3 tables above you have a customer ID which is in the Cutomers Table and also in the Invoices Table.<br>Then you have a part number in the Parts Table it also has to be in the Invoice Table<br>So you have a link between Customers and Invoices and link between Invoices and Parts<br><br>So if customer 123 orderd part ABC which happens to be invoice number 987.<br>Now if you change the part number for part ABC to DEF then when you run your query it will not show anything because part DEF is not in the original Invoice.<br><br>I think that's what your problem is. You said you changed values and some of the fields go blank. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[earnold]

DougP,<br><br>Thanks for replying!!!&nbsp;&nbsp;I have definitely had the problem that you described--I've learned best from my mistakes.&nbsp;&nbsp;However, I've never experienced what I'm seeing in this particular form.&nbsp;&nbsp;It seems like I tend to find every glitch in a program.<br><br>I only have 1 table (or query) linked to the form.&nbsp;&nbsp;I've made a query containing all the table fields just to sort the data for easy editing and entering purposes.&nbsp;&nbsp;The fields are named the same in the table and query.&nbsp;&nbsp;<br><br>When I open the form in form view, the data in certain fields is 'hidden' from view, but when I tab or click in the particular fields, the data becomes visible again (until I tab or click out of the field).&nbsp;&nbsp;The data is the table/query.&nbsp;&nbsp;Very Strange...

 

[adstam]

Hi, i seem to have the same problem as earnold has (or had?). For 1 thing i'm sure, the data is even in the textbox but seems to be transparant. When bringing the cursor in the textbox it can be move through the text whitout seeing it.
In my case it's happening only on textboxes with 'calculated' texts (or dates).

Earnold, have you found a solution?

:-(

 

[scking]

You both seem to have a problem which is not evident. I love these, they require some troubleshooting expertise and a familiarity with the tools available. I'm assuming you are both the authors of the databases and there is no OnCurrent code which may change the states of the form ForeColor or BackColor.

-Inspect the source of the data for the form. Is it a query or table? Is the data present? If it is a query run the query separately to ensure it works properly.

-Try adding a little Debug code to the OnCurrent event for the form and move through a few records. Then inspect the output in the debug window.
Debug.Print Control 'Prints the actual value in the control

-From the debug window, with the form open to a bad record, query the control to see what it says.
Forms(&quot;YourFormnameHere&quot.YourControlNameHere

This should give you a good start to finding the problem.

Steve King Professional growth follows a healthy professional curiosity