column width in continuous form

[Fev]

Hi
I have a continous sub form (based on the advice on not using a
datasheet in this forum). I would like to show and hide columns based
on check boxes in the main form, however when a column is hidden based
on the check box, I would prefer not to have a blank space. Is it
possible to change the column width as well, so that if columns 1 and
3 are hidden, columns 2 and 4 will appear next to each other. I have
tried this code, but am not getting the result I would like:
Private Sub chkPta_Click()
If chkPta = -1 Then
Me!frmLSMBreakdown.Form!txtPta.Visible = True
Me!frmLSMBreakdown.Form!lblPta.Visible = True
Me!frmLSMBreakdown.Form!txtPta.ColumnWidth = 1.5

Else
Me!frmLSMBreakdown.Form!txtPta.Visible = False
Me!frmLSMBreakdown.Form!lblPta.Visible = False
Me!frmLSMBreakdown.Form!txtPta.ColumnWidth = 0
End If
End Sub
Thanks
Heather

 

[Arvin Meyer]

Yes, as a matter of fact, just setting the ColumnWidth property to zero is
all you need to do. Don't even bother with the Visible property.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://access.mvps.org
Co-author: "Access Solutions", published by Wiley