I don't know why the detail section of MS Access report has been
repeated multiple times if the number of records return by the query
is too large. I put a TextBox control in the detail section and write
some code to get all the records and put those records into the
TextBox control. I need someone to help me.

Hmmm?? You wrote code to put multiple records into the control?

Anyway, it's most likely that your form is showing in Continuous Forms view.
Open up the form as a user would, click on View on the menu bar, then click
Form View (you might have to click the little down-arrows in the View menu
to see all the options).

Continuous Forms shows many copies of the form's detail section, a copy for
each record, as long as it fits with the size of the form. Form View shows
only one detail section, for the current record. There is also Datasheet
View, which looks like an Access table or query display but still has many
features of forms.

Bruce Pick

"Yi" <fs_yi2002 (AT) yahoo (DOT) com.cn> wrote