Thanks. This may be an impossible task. The users need Unhide Columns,
because they like to change the fields that are displayed. I suppose I
could
give them a custom Unhide Columns dialog box, listing only the columns I
want them to be able to use. That may be the only solution.
Would be nice if there was a Form_ColumnsChanged event that could manage
it,
or (better), under control properties, where it says Display When: instead
of Screen and Print, have Screen, Print, Form View only, and Datasheet
View
only. That would be nice; but it isn't.
Thanks.
"tina" <nospam@[EMAIL PROTECTED]
> wrote in message
news:SWmZk.52218$_Y1.38201@[EMAIL PROTECTED]
> well, you can set the control's Width property to zero in Design view,
> then
> add code to the form's MouseUp event to set the control's ColumnHidden
> property to True. you'll need to add a custom menu that does *not* have
> the
> Unhide Columns option, or just remove the menu bar entirely.
>
> hth
>
>
> "Neil Ginsberg" <nrgins@[EMAIL PROTECTED]
> wrote in message
> news:fB6Zk.9052$be.4012@[EMAIL PROTECTED]
>> Is there a way to control which columns the user displays in Datasheet
> view?
>> I have certain fields hidden, and I want to prevent the user from being
> able
>> to display them by going to Unhide Columns.
>>
>> Is there any event that is triggered when the columns in Datasheet view
> are
>> changed, or is there some other way to control which columns are
>> displayed
>> in Datasheet view? I'm using Access 2003.
>>
>> Thanks!
>>
>>
>
>
|
