Datasheet Subform Question

  • Thread starter Thread starter Marty L
  • Start date Start date
M

Marty L

I have a form with a subform. The subform is setup to be viewed in
"DataSheet View" only.
The subform could have more records than the 'area' allotted on the form, so
the user will need to scroll the datasheet.

Problem - how do I allow scrolling without allowing the user to change the
column width of the fields on the subform? If I change the subform property
ENABLED to NO, then the column width can't be changed, but the user can't
scroll either.

(there are a number of subforms, and the field widths are all set to give a
nice appearance, with one subform showing the totals of the scrollable
subform above it)
 
Problem - how do I allow scrolling without allowing the user to change the
column width of the fields on the subform? If I change the subform property
ENABLED to NO, then the column width can't be changed, but the user can't
scroll either.
Click to expand...

I'd suggest using a Continuous Form view rather than a datasheet. It
can be made to look very much like a datasheet; just drag all the
textboxes to the top of the form, cheek by jowl, and drag the bottom
of the form up to the bottom of the textboxes. The users won't be able
to alter the appearance but will be able to scroll.
 
Back
Top