Control Visiility in Datasheet

[lizray]

I have a control on a subform that displays in datasheet view. Can anyone tell me how to programatically make this control ( and hence its column) be visible or not?. I have tried setting the "visible" property to No and it still displays

 

[TheAceMan1]

How are ya lizray . . .

Have a look here You Can Do That with Datasheets?


See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

lizray . . .

Use the following two lines anywhere in code to Show/Hide:

[blue]   Me.[i]controlname[/i].[purple][b]ColumnHidden[/b][/purple] = True [green]'To Hide[/green]

   Me.[i]controlname[/i].[purple][b]ColumnHidden[/b][/purple] = False [green]'To Show[/green][/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[lizray]

Thanks so much TheAceMan..the name says it all.
It works perfectly