Can't see choices in Subform wizard

N

neil.mclean

When creating Subforms the Wizard asks if I want to choose from a list. As
the table names are long the I can't see the choices properly.
e.g. Show tblMeetingdetails for each record in tblCawse Details using
??????. How can I see the bit hidden by the scrollbar? Something like F2
does for the SQL code
 
R

Rick Brandt

When creating Subforms the Wizard asks if I want to choose from a
list. As the table names are long the I can't see the choices
properly.
e.g. Show tblMeetingdetails for each record in tblCawse Details using
??????. How can I see the bit hidden by the scrollbar? Something like
F2 does for the SQL code
Click to expand...

So drop the wizard. Build both forms and then drag the one you want for the
subform from the db window into the design view of the one you want for the
parent. Set the MasterLink and ChildLink properties on the subsequent subform
control as required and you're there.
 
N

neil.mclean

Thanks Rick but I have an added complexity that I am dragging fields in from
an AS400 database wose field names are spurious to say the least so I was
hoping that the wizard was going to give me the answer. I have worked out how
to do it manually but I would still like to know the answer to the above
problem if possible
 
R

Rick Brandt

Thanks Rick but I have an added complexity that I am dragging fields
in from an AS400 database wose field names are spurious to say the
least so I was hoping that the wizard was going to give me the
answer. I have worked out how to do it manually but I would still
like to know the answer to the above problem if possible
Click to expand...

People have been complaining about truncation of the lists in the wizards for
years. No work-around that I know of except to not use them.
 
Top