• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 63
  • Last Modified:

subform column widths will not hold size after saving

access 2010

Never had this issue before.

Subform column widths will not hold have going into subform  and changing there...

Subform column widths will not hold have going into Main form  and changing there


Thanks
fordraiders
0
Fordraiders
Asked:
Fordraiders
  • 2
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
is it a datasheet?
0
 
FordraidersAuthor Commented:
yes.,...
0
 
Dale FyeCommented:
FordRaiders,

See my article here for some ideas

Short answer is recent versions of Access have dorked this up.  When I want columns placed in a certain order and a certain width, I create a procedure to do it and call that procedure from the Form_Load event.

Private Sub ColumnWidths

    me.controls("txt_Field1").columnwidth = 1 * 1440
    me.controls("txt_Field2").columnwidth = .75 * 1440
    me.controls("txt_Field3").columnwidth = 1.25 * 1440

End Sub

Note that I've referenced the control name, not the field name.
0
 
FordraidersAuthor Commented:
Dale, Thanks Yes, I found this.!! worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now