By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,544 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,544 IT Pros & Developers. It's quick & easy.

Datasheets - resizing/reordering cloumns by hand, does not stick

P: n/a
I have several data sheet sub forms in my application. If I resize or
reorder columns by clicking and dragging, in some forms my actions are
remembered the next time the form is opened, in other forms the form
returns to the defaults.

How can I get the datasheet sub forms to remember the way I sized and
ordered my columns? Is is a form property, or can I code it?


Private Sub Form_Unload(Cancel As Integer)
Me.RememberColumnWidthsAndOrder ':O)
End Sub

Nov 21 '08 #1
Share this Question
Share on Google+
1 Reply

P: n/a
I don't think there is a column width property in Access for table
columns. But if you click the Save Icon after changing a column width
in your datasheet (subform) - Access should remember that setting. What
you don't have is a way to dynamically change the size of the subform -
via dragging (unless you write a ton of code - not easy). But you could
have a button, for example, where you can change the width of your
subform to accommodate when you need to widen your columns.

dim subFrmWidth as long
'--set the value of subFrmWidth
Private Sub Command1_Click()
Me.frmAsub.Width = subFrmWidth
End Sub

*** Sent via Developersdex ***
Nov 21 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.