goaway1234
Programmer
I just migrated an application from Access97 to 2003. One of my forms contains three sub-forms, two of which are displayed as data sheets. In one of the datasheet subforms, Access just randomly decides to stop filling the cells with text.
This is where things get wierd: Although, no text is displayed in any cell, you can move the cursor in the field as if there are characters there. When I have the form open, and I use the immediate window to inspect it, its RecordSource property is fine. Its Recordset property also appears to be fine. The Recordset property of the form has the correct RecordCount, and when I move to a different record in the form, and then access the value of a field in the Recordset property, it gives me the correct value. Every property that I inspect in the immediate window gives me exactly what I expect, except that no text is displayed in the datasheet.
What the $#@#%@^@~!! is going on here?
This is where things get wierd: Although, no text is displayed in any cell, you can move the cursor in the field as if there are characters there. When I have the form open, and I use the immediate window to inspect it, its RecordSource property is fine. Its Recordset property also appears to be fine. The Recordset property of the form has the correct RecordCount, and when I move to a different record in the form, and then access the value of a field in the Recordset property, it gives me the correct value. Every property that I inspect in the immediate window gives me exactly what I expect, except that no text is displayed in the datasheet.
What the $#@#%@^@~!! is going on here?
