The problem is that the fields to be hidden in datasheet view need to be
available in form view. Some of the fields are hidden in form view.
(Unfortunately, setting Visible=False in form view doesn't equate to the
field not being available in datasheet view.) Other fields just need to
not
be available in datasheet view for coding reasons. Thus, the query needs
to
contain those fields.
I could switch queries when the view changes; but that would requery the
recordset, which would create other problems.
"Allen Browne" <AllenBrowne@[EMAIL PROTECTED]
> wrote in message
news:49350a2e$0$18650$5a62ac22@[EMAIL PROTECTED]
> Simplest way is to create a query that delivers only the fields you
want.
> Then there is nothing for the user to unhide.
>
> If that's not suitable, perhaps Continuous View would suit, rather than
> Datasheet View.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "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.
>
|
