Freeze fields on a form

[Dan Knight]

I have a form that show multiple fields (Plant Number, Cost Code, Cost Type,
Estimate ID) identifying a Cost Estimate.
Each Cost Estimate records includes fields for Estimate Cost, Committed
Cost, Incurred Cost, and Forecast Cost (plus other fields).

The form is set up with the Cost Fields on the left side, however, there is
not enough space (given monitor size/resolution) to display ALL the fields at
once.

My users (who are use to working in Excel) would like the ability to "freeze
panes like we can do in Excel", whereby the 4 or 5 "identifying" fields are
stationary, while the various Cost Fields scroll right to left.

I've toyed with the idea of using the TabControl to stack my various Cost
data, whoever that would also entail using syncronized(sp) subforms, plus all
the data resides in one table.

Any ideas on how to provide the perception that the left "columns"
(controls) are being scrolled under the "frozen" pane?

 

[Lori]

Set the default view in properties to "datasheet".

 

[Klatuu]

In datasheet view, you can right click the column header(s) then choose
freeze or unfreeze just like you can in Excel.