Arno, Rick,
Firstly, to answer your questions: Access 2003, and the form remains in
Continuous Mode. Dragging the shrunken form vertically exposes all the
missing records.
Anyway, I have found the problem and have a workaround fix, although I am
not sure I understand what is going on.
I did what I should have done from the start -- I went back to a saved
version of the form from a time when it was working OK and did a comparison
of form properties, one by one. There had been a number of accumulated
changes, but the one which "caused" the problem was RecordSource. In the
newer "faulty" form, RecordSource was blank. Let me explain...
Originally the form listing was based on a query from a single table, and
the table name was set as the RecordSource. All worked OK. With further
development, the record source for the form became a union of queries from
two separate tables. This query is developed in the calling form and is
already available as a record set when the problem form is called. So when
I now open the latter form, I set the form's Recordset property to the
existing recordset. This saves exporting the query's rather complex SQL
from the calling form to the problem form (as OpenArgs?) to be set as its
RecordSource and, since the recordset is already in memory, saves
duplicating the query in the child form.
According to the Help file, setting the Recordset property of a form is
supposed to update the form's RecordSource property accordingly. So, it
seemed logical to delete the old RecordSource value from Design Mode (ie the
single table) as it was no longer valid. But doing so seems to be what
caused the shrinking problem. Anyway, my workaround for now is to restore
the old table name as the form's default RecordSource value, even though it
is not used.
Why would this cause the form to shrink? (BTW, I set the Recordset property
in the Open event -- also tried using Load event, no difference.)
Thanks again for your help.
--
Cheers,
Lyn.
"Arno R" <ar****************@tiscali.nl> wrote in message
news:42**********************@dreader2.news.tiscal i.nl...
Lyn,
What version of Access is this ? Corruption here ?
If the problem persists I would create a new form, copy and paste the
controles and just see how this form 'acts'.
If it's allright you can also copy the form's code.
Arno R
If I open from the DB window, I get the same small size. It is only if I
start in Design View and press the Form View button that the form opens
full
size.
I must have done something recently that has caused this because the form
was working fine for weeks. But although I have tried backtracking to
find
the cause, it still eludes me.
