SubForm Formatting - 2 Questions

J

jdb

I need to create two subforms:

the first is created already, butthe format looks like an excel spreadsheet,
in the design view it looks fine, but in the form view is looks like a
spreadsheet - how do I stop this? I think I want a continuous subform, but do
not want it to have the ugly spreadsheet formatting.

The second is a subform connected to a table that lists various affiliations
for an individual in the main table. The two tables are linked one-to-many
based on a unique ID number.

The table is basically a bunch of yes/no boxes, and I want to subform to be
just a bunch of checkboxes. I haven't started designing it yet, but
anticipate running into the same problem as above (and more, i'm sure).

Your help is appreciated.
 
G

Gary Miller

It sounds like you have your subform set to DataSheetView
instead of ContinuousForms. Form Properties - Format -
DefaultView
 
Top