[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

subform column widths will not hold size after saving

Posted on 2016-09-21
4
Medium Priority
?
57 Views
Last Modified: 2016-09-21
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
Comment
Question by:Fordraiders
  • 2
4 Comments
 
LVL 24
ID: 41809223
is it a datasheet?
0
 
LVL 3

Author Comment

by:Fordraiders
ID: 41809243
yes.,...
0
 
LVL 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 41809256
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
 
LVL 3

Author Closing Comment

by:Fordraiders
ID: 41809629
Dale, Thanks Yes, I found this.!! worked.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question