Split form auto resize rows and columns

[data808]

I have a split form with the datasheet on the bottom and noticed that the rows and columns are saved if the user changes its size. How do I save a default size so that when this split form is opened the next time, it will go back to where I had it? Either that or lock the split form's rows and columns so that the user cannot resize anything. I already took out the splitter bar which was great to get rid of that. From what I heard its not possible to lock the rows and columns though so I guess just the default sizing of it on when ever someone opens this split form. Any ideas?

[Missinglinq]

Not sure if this will work for the Datasheet part of a Split Form, but it works for a regular Datasheet View Form, per Access Help:

Private Sub Form_Load()
  Me.Field1.ColumnWidth = -1
  Me.Field2.ColumnWidth = -1
End Sub

You'd have to do it for each column, of course. Out of curiosity, why not let users save their preferences? If this is a multi-user environment, it should be split into a Front End/Back End configuration, with each user having a copy of the Front End (with everything except the Tables in it) on their hard drive and the Tables on a shared drive in the Back End. Any changes made to the display of a Form would only effect the Form on that user's machine.

Linq ;0)>

[data808]

It is a multi user environment and I do have the back end and front end set up. How ever different users are on rotation to these computers with the front end file so I would like it to be uniformed. Thanks I'll try it out and let you know how it works.

[data808]

I decided to go with a report for now and it seems to work out great because I can set the column width and row heights in the report's design view and it will be static for the user even though they touch the split form's columns the reports stay the same. So for now, I won't need this code but it will be good to have in case I need it in the future. Thanks so much for the reply and helping out. I appreciate it.