Freezing a column on continuous form

J

John

Hi

Is it possible to freeze the left most column on a continuous form?

Thanks

Regards
 
J

John

Thanks. Is there a way to programmatically freeze the first column in
datasheet view?

Thanks again.

Regards
 
A

Arvin Meyer MVP

No, the property is read only. Here's some of the Access 97 help file which
is the most complete on the subject:

You can use the FrozenColumns property to determine how many columns in a
datasheet are frozen. Frozen columns are displayed on the left side of the
datasheet and don't move when you scroll horizontally through the datasheet.

Note The FrozenColumns property applies only to tables, forms, and queries
in Datasheet view.

Setting

The FrozenColumns property is set by Microsoft Access when you click Freeze
Columns on the Format menu.
In Visual Basic, this property setting is an Integer value indicating the
number of columns in the datasheet that have been frozen by using the Freeze
Columns command. The record selector column is always frozen, so the default
value is 1. Consequently, if you freeze one column, the FrozenColumns
property is set to 2; if you freeze two columns, it's set to 3; and so on.

This property setting is read-only in all views.

Remarks

When you freeze columns by using the Freeze Columns command, Microsoft
Access automatically moves the columns to the leftmost edge of the datasheet
in the order in which you freeze them. For example, if you freeze three
columns, these become the first, second, and third columns in the datasheet.
Because the record selector column is always frozen, the FrozenColumns
property in this case will be set to 4. The three columns you freeze will
have their ColumnOrder properties set to 1, 2, and 3 (in the order they are
frozen).

If you click Unfreeze All Columns on the Format menu, all frozen columns
will be unfrozen, and the FrozenColumns property will be set to 1.

Note The Unfreeze All Columns command will not restore the original order
of columns if the Freeze Columns command caused the column order to change.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top