Unbound Text Box Not Displaying Data

[JamesJ]

In access 2007 a split form I have the following in the On Current of the
form to display
the number of records:

If Me.NewRecord Then

Me!txtCount = "0 Item(s)"

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

I have 3 fields in the form: DvdID, DvdMovieTitle and DvdSynopsis.
When DvdMovieTitle and DvdSynopsis are both Enabled No Locked Yes txtCount
is fine.
But, when I set DvdMovieTitle to
Enabled No Locked Yes and DvdSynopsis (memo field) to Enabled Yes Locked Yes
txtCount displays nothing. By nothing I don't mean 0 I mean nothing.
If I set DvdMovieTitle to Enabled Yes Locked Yes and DvdSynpsis to Enabled
No Locked Yes it work fine.
It seems that something happens when I set the memo field to enabled yes
locked yes.

Has anyone ever heard of this??
Any ideas an a way around this?

Thanks,
James

 

[JamesJ]

One more thing. Even the Navigation Button, when showing, acts the same way
So I don't believe it's the code.

James

 

[JamesJ]

Found out another thing.
This anomaly doesn't occur with Continuous forms.
I took the split form and pasted it and changed it into a continuous form
and all seems well.
Now I need to decide whether I want to convert 10 forms to continuous forms.
If you were wondering I needed the memo field enabled 'cause of I need the
vertical scroll bar to scroll to see all the data.

And no, I don't talk to myself all the time.

James