| re: To hide columns in a form with datasheet view
Simon wrote:[color=blue]
> Dear reader,
>
>
>
> In a form with the property "Default view" as DataSheet I like to hide some
> fields in the datasheet view.
>
> It is possible to manage this with the command Format>>Unhide columns, a
> form pops up with tick boxes to hide or unhide the columns.
>
>
>
> Is there VBA code available to do the same.
>
>
>
> Me.FieldName.visible = False
>
>
>
> Has no effect on the presentation in the datasheet view.
>
>
>
> Tanks for any help.
>
> Kind regards,
>
> Simon van Beek
>
>
>
>[/color]
Me.Controls("NameOfControl").ColumnHidden = True
| 
