?
Solved

Sub Form column Size to be Fixed

Posted on 2012-03-28
2
Medium Priority
?
398 Views
Last Modified: 2012-03-28
Hi team,

I have a sub form inserted into a main form.  Now I want to fix the column width of each and every column that is showing up in the Sub form.

I have attached a sample database.  In this you will have a from named as Testing.  In this I have inserted a Sub From, Now I should be able to fix the coloumn with of each of the column of data that is showing up.

Please adivse how do I achive this.

Thanks,
Sandesh.
Check-Payment.accdb
0
Comment
Question by:Sandesh555
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 1500 total points
ID: 37777932
Use the form load event procedure as in this example...

Private Sub Form_Load()
' 1440 twips per inch ; 567 twips per cm
Me.Invoice.ColumnWidth = 567
Me.Open_Amount.ColumnWidth = 1440
Me.ID.ColumnWidth = 10
End Sub
0
 

Author Comment

by:Sandesh555
ID: 37777985
Thanks....
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Implementing simple internal controls in the Microsoft Access application.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

615 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