Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem entering data in form view

Status
Not open for further replies.

earnold

Technical User
Jul 31, 2000
4
US
Greetings Gurus,<br><br>I've made a seemingly simple database that has one table, one query, one form created from the table, and several macros. The table has 183 fields, and all fields are included in the form. <br><br>The problem (in form view) is this...If data in certain fields and in certain records is edited or changed, the data disappears in those particular fields. 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 transparent and in front of an imported picture, the text is colored purple (8388736), 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 with no problems. 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 some of the fields in form view disappear after tabbing/data entry??<br><br>A wierd thing also happens when tabbing/entering data.&nbsp;&nbsp;When the cursor enters fields 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 character(s).&nbsp;&nbsp;I've tried compressing & repairing the database, re-linking the text boxes with their control sources, and everything else I know.<br><br>Arrrrrggghhhh.&nbsp;&nbsp;It must be something simple...<br><br>Any assistance/advice would be appreciated.&nbsp;&nbsp;Thanks, Eric.<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top