Sub Form column Size to be Fixed

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
Sandesh555Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
peter57rConnect With a Mentor Commented:
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
 
Sandesh555Author Commented:
Thanks....
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.

All Courses

From novice to tech pro — start learning today.