Form design

  • Thread starter Thread starter PC Datasheet
  • Start date Start date
P

PC Datasheet

You can not Freeze columns in a form like you can in a spreadsheet. However, if
your table(s) are designed as Normal, you casn display your data in spreadsheet
format with a crosstab query. You would have to code for dynamic columns with 52
scenarios i something like a Select Case to "roll" the screen 1 week at a time.
 
Is it possible to construct a form that acts somewhat like a spreadsheet ?

The items would stay "frozen" on the leftmost part of the form, and text
boxes (52 or so) representing weeks in the year would "roll" horizontally to
the right of the item.

Thanks !
 
If you are displaying a form as a DataSheet then you can freeze the leftmost
n columns using Format | Freeze columns.

Ron W
 
Back
Top