column widths in datasheet

[Guest]

Hi, how can I prevent users to change column widths of forms that are in
datasheet view.
I've noticed that if you change column width by simply resizing it by
draging it than it will appear next time (when starting an application) as
default value.
Furthermore can I remmember each user settings for column widhts?

thanx

alek_mil

 

[Guest]

If the datasheet will be displayed as a subform, even if the users will
change the layout of the fields, every time they will open the form, the
layout will return to the Old layout.

To limit the users from changing the size of the fields, change the form
view from DataSheet to Continous From

 

[Keith]

Hi, how can I prevent users to change column widths of forms that are in
datasheet view.
I've noticed that if you change column width by simply resizing it by
draging it than it will appear next time (when starting an application)
as
default value.
Furthermore can I remmember each user settings for column widhts?

Not that I know of but as a workaround you could force users to download
their user-interface from a server. The file they download would be a copy
of your development file, thus retaining the column widths set by you. This
all assumes you've "split" your database (the on-line help will tell you
more if you need it).

Regards,
Keith.
www.keithwilby.com

 

[Brendan Reynolds]

Option Compare Database
Option Explicit

Private Sub Form_Open(Cancel As Integer)

Me.TimerInterval = 250

End Sub

Private Sub Form_Timer()

Dim ctl As Control

For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then
ctl.ColumnHidden = False
ctl.ColumnWidth = -1
End If
Next ctl

End Sub