Unbound Text Fields Quick Displaying Data

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

I just spent about a day revamping my Access 2007 db. I noticed that when
I was all
finished any unbound text boxes I have on the forms (aboiut 1 per form)
stopped displaying data.
I made no changes to these fields and they displayed properly in a backup I
have from a couple days ago.
Before I start replacing my 10 or so forms and hoping something like this
doesn't happen again,
might there be any way I can salvage these forms and get the data to display
again?
When I make the same changes to the backup form(s) it seems fine. I've
looked and looked to see
if there is some difference between the forms but I can't find any.

Thanks,
James
 
Seemed to have fixed this 'odd' problem
First, sorry 'bout my spelling - Quick should be Quit in the subject.
Anyway.
The unbound text box in question, txtCount, I use to display the
number of records being displayed with the following in the On Current of
the form:

If Me.NewRecord Then

Me!txtCount = "0 Item(s)"

Else
Me.RecordsetClone.MoveLast
Me.txtCount = Me.RecordsetClone.RecordCount & " Item(s)"
End If

The form(s) are split forms with the datasheet on the left
Since I want these forms for viewing only l want to set all fields to
Enabled No and Locked Yes.
I found I had left a memo field, that I have in all my tables, at Enabled
Yes. When I changed it to
Enabled No the unbound text box began displaying the data. Don't know why
this would cause the
unbound textbox to quit displaying data. The unbound is Enabled No Locked
Yes.
Anyway, If I knew what I was doing I might have figured it out sooner.

James
 
Back
Top