disable datasheet rowheight adjust??

[deBassMan]

Hi all

MS Access 2K/2003; Win XP Pro

The rowheight in a datasheet in Access casn be dragged and resized by the users - but how can this functionality be disabled??

thanks for any ideas you may have

 

[RuralGuy]

The DataSheet view is easy to use but it has a number of drawbacks as you have discovered. AFAIK the only solution to your issue is to create a Continuous Form view where you can completely control such issues. You can make the Continuous Form look exactly like the DataSheet view.

 

[Lister]

One other option is to set the RowHeight at runtime for the form. Or give the user the option of returning it to a defult height.

Hope this helps.

 

[deBassMan]

I've considered the continuous forms approach ...

initially setting the datasheet height is irrelevant if the user can drag it taller or shorter

there must be a way of determining if a window is displaying a vertical scrollbar.


there is an answer out there .....

 

[RV]

there must be a way of determining if a window is displaying a vertical scrollbar.

Why would you want to ?

RV

 

[Lister]

initially setting the datasheet height is irrelevant if the user can drag it taller or shorter

The reason would be, yes they can move them about if the user wants to. But once the form closes and is re-opened the rowhights (and widths if you like) would all be reset. This approach allows for flexibility when the user is in the form without having to worry about them leaving a great mess for the next user.

If you want ridged field cells that are consistent and can’t be moved by the user, stop mucking around with datasheets and look at building a continuous form.

 

[deBassMan]

... I think I'll go with the more customisable continuous form idea - thanks all