Recent content by rockstar283

'Not Working' means the columns width is not getting automatically set in the form view. You are Correct about the second part.

Thanks mate..but its not working :banghead::banghead: Here is my current code behind the subfrm Private Sub Form_Current() Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.ControlType = acTextBox Then ctrl.ColumnWidth = -2 Next End Sub Private Sub Form_Load()...

to clarify more: Got one Navigation Form NavFormA NavFormA has different NavigationButtons. Button1 has FormB as its 'Navigation target name' i.e. it loads FormB when Button1 is clicked upon. FormB has a subform subfrmC in it and subfrmC has datasheet in it. I want to the columns of subfrmC...

I want to use the new code in OnClick event of the Navigation tab..so that everytime, the user clicks on the tab name, all the columns in the corresponding subforms will have proper width

I have developed an Access app, which has different navigational tabs which open up different forms. e.g. Tab A has Form A inside it and Form A has SubForm A1 inside it. For some reason, the following code is not working on any of the fields Me.YourFieldName.ColumnWidth = -2 Can anyone please...