Solved

Sub Form column Size to be Fixed

Posted on 2012-03-28
2
391 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

738 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