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

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

Guest

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
 
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.
 
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
 
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.
 
Back
Top