hide/unhide fields (1 Viewer)

[nick5196]

I have a sub table on my switchboard. I wish to have a button which opens a set of tickboxes allowing the user to select which fields are shown within the subtable. The "student template" ON MS Access 2007 features this.

Thanks allot
Nick

 

[SpentGeezer]

try this, not exactly what u wanted...

 

[nick5196]

Thanks for your help but this is not exactly what I am looking for.

I have found how to open the "unhide columns selector" i want, Just rightclick the subtable and select "unhide columns". Basically i just want a button which does this.

I have attached an image of the box i mean.

Thanks a lot
Nick

 

[smig]

use the columnsWidths
(use twips)

dim strWidths as string
 
if me.checkbox1 = true then
 strWidths  = "1000;"
else
 strWidths  = "0;"
end if
 
if me.checkbox2 = true then
 strWidths  = strWidths  & "1000;"
else
 strWidths  = strWidths  & "0;"
end if
 
if me.checkbox3 = true then
 strWidths  = strWidths  & "1000;"
else
 strWidths = strWidths  & "0;"
end if
 
me.list.columnsWidths = strWidths

 

[vbaInet]

ColumnHidden property:

Me.ID.ColumnHidden = True / False

Datasheet View only by the way.

 

[smig]

what I suggested is for multi columns ListBox BTW