I have an split DB app that seems to have a corrupted table in the backend. The problem is the visibility of one of its fields when either the table or query of the table is opened directly, but not an issue when referenced as RecordSource for a form, report or DAO Recordset, there are NO fields "Hidden". One of the app's primary forms has the query of the table as its RecordSource and the data for the troublesome field displays as always:
Query: Form: The form, in design view, clearly reveals that the text box is bound to the troublesome table field "EmailWk".
I put together a general module to audit the table content for the troublesome field:
The above audit displayed a multitude of email addresses in the IM that are contained in the DB.Code:Option Compare Database Option Explicit Private Sub AuditQAsilomar() Dim rs As DAO.Recordset Set rs = DBEngine(0)(0).OpenRecordset("QAsilomar") rs.MoveLast If rs.RecordCount > 0 Then rs.MoveFirst While Not rs.EOF If Not IsNull(rs!EmailWk) Then Debug.Print rs!EmailWk rs.MoveNext Wend End If rs.Close Set rs = Nothing End Sub
I've tried new queries, copying the backend mdb, copying structure only followed by an append, simple copying of the table, even moving the position of the "EmailWk" field in the table's design view.
Once again, I checked the open table view to insure the field IS NOT HIDDEN.
What else can I try?