Continuous Form to Look like Datasheet ..... how to freeze "colum

T

TimS

Hi,

In using a continuous form instead of a datasheet - so that the formatting
and look can be controlled pretty well to look like an excel sheet - I am
missing one way of controlling the form - to be able to freeze some "columns"
- as the sheet is pretty wide (for those with low res. screens).

Any ideas how to do this? My thoughts moved to using a 'virtual' scroll bar,
hiding and moving the controls on the form so that it looks as if you are
scrolling ..... but before I dive into the code for this - I hope you may
have a easier or better way .... ???

Thanks for any help or guidance you may be able to give,

Tim
 
S

Stephen Lebans

The simplest method is to go back to Datasheet view which resembles an
Excel Sheet more than Continuous view does anyway.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
T

TimS

Thanks Stephen,

One of the further reasons for using a continious form is that I have a
bunch of totals for each field in the form footer + use these to calculate
and display also other items on the same form footer. As far as I know - I
cannot do this with a datasheet + also need (if scrolling) to have the totals
at the bottom move with the top part (if they are part of a different form).


Tim
 
S

Stephen Lebans

You could keep your Header/Footer arrangement and use a SubForm in
Datasheet view.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Top