cell width in datasheet and subreport size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have 2 questions.

1.How do use change the width of a datasheet cell?
I have played around with width property but when I load the form and populate
my subform(datasheet) the cell width are always the same size.
A user can grab the column edge and resize, however I want to set the width
my-self at design time or run-time.

2.My subform when scrolled to the right has almost an entire page width of
dead space to the right of the last column. It can scroll as far over till
only last column is shown.
How do I set it so that you only can scroll to the last column and the
scroll bar
stops allowing to see more empty space?

thanks

Chris
 
1. To change the width of your datasheet in your subform you have to open the
subform without the parent form, change the width, and it will stay that way.
 
Hi,

I have 2 questions.
Click to expand...

I have one answer which should solve both.

Rather than using a Datasheet for your subform, set the form's Default
View to "Continuous Forms". Set up the form by dragging all the
textboxes (and other controls) to the top of the detail section, lined
up with no space between them; drag the bottom of the detail section
up to the bottom of the textboxes; and make the subform Header visible
for column caption labels.

You'll get the look of a datasheet without the option for the user to
mess it up.

John W. Vinson[MVP]
 
But you have to knew that by using continus form his losing advantages that
access gives by using data sheet
like:
the user can make field remove, enlarge them, shorten them, sorting, filter
and al that using command exsist in the toolbar
 
But you have to knew that by using continus form his losing advantages that
access gives by using data sheet
like:
the user can make field remove, enlarge them, shorten them, sorting, filter
and al that using command exsist in the toolbar
Click to expand...

True... but then the OP was requesting that the user's ability to
change the size of the columns was the *problem*! Unfortunately you
can't get these other advantages without the disadvantages; and (with
some code) you can replicate the sorting, filtering, etc. toolbar
capabilities.


John W. Vinson[MVP]
 
Back
Top