FrozenColumns

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

Guest

Hi,
I want to use on Datasheet View On open code that will freeze the columns,
organize columns and update the widhts in a way that form will open in a same
format each time.

I have been able to write code that peforms:
* order of columns
* widhts of columns

But i have not been ablo to figure out how to freeze a column. I have
searched comments, but not able to find real comment on this. Any help would
be appreciated. I want to have it in Datasheet View.

BR
MakeLei
 
Hello Makelei.

Makelei said:
Hi,
I want to use on Datasheet View On open code that will freeze the
columns, organize columns and update the widhts in a way that form
will open in a same format each time.

I have been able to write code that peforms:
* order of columns
* widhts of columns

But i have not been ablo to figure out how to freeze a column.
I have searched comments, but not able to find real comment on this.
Any help would be appreciated. I want to have it in Datasheet View.

BR
MakeLei
Click to expand...

Have you tried the FrozenColumns property of the datasheet?
Assign an integer value to specify the number of frozen columns.
The columns are frozen starting from the left, the record selector
column is also counted, so if you wanted to freeze the first two
data columns, specify the number 3.
All from online help.
 
Hi Wolfgang,

I have seen that online help, but for a reason or other I am not able to get
it to work... Could you please give me a code for that. I have seen only one
comment in this forum and comment was to ignore the sentence...

BR
MakeLei
 
Hello Makelei.

I have seen that online help, but for a reason or other I am not able to
get it to work... Could you please give me a code for that. I have seen
only one comment in this forum and comment was to ignore the sentence...
Click to expand...

Sorry, I was too fast. It seems to be impossible to do it in datasheet
view. Online help says: read only in all views.
But for a table, you can modify the FrozenColumns of the TableDef object
before opening the datasheet of the table.
 
Back
Top