Hiding controls

[lxh]

Hi All

I have a form that has a subform. The subform is in datasheet view, is it possible to hide some of the columns (controls)?. I want to hide the Primary and foreign keys etc from the user. I have put them in to enable me to synchronise the forms. The visible properties (along with a lot of the other) etc., don't seem to work in datasheet view. Does any one have a solution?

Many thanks for any comments
Lex

 

[spacepro]

Hi All

I have a form that has a subform. The subform is in datasheet view, is it possible to hide some of the columns (controls)?. I want to hide the Primary and foreign keys etc from the user. I have put them in to enable me to synchronise the forms. The visible properties (along with a lot of the other) etc., don't seem to work in datasheet view. Does any one have a solution?

Many thanks for any comments
Lex

Try opening the subform on it's own and go into design view and then setting the visible properties to false then save the form. Then open your main form with the subform in and try that.

Hope this helps

Andy

 

[lxh]

Re: Datasheet controls

Try opening the subform on it's own and go into design view and then setting the visible properties to false then save the form. Then open your main form with the subform in and try that.

Sorry Andy that doesn't work in Datasheet mode - but thanks for the reply.

I have however just found the following articles which does far more than I thought was possible with datasheets - take a look

Controlling DataSheet Attributes

Thanks
Lex

 

[spacepro]

Hi Lex,

It seems to work for me but hey the article is interesting.

Hope you have solved your problem

Andy

 

[Becca]

Reply - better late than never

Just in case anyone needs an answer to this problem - you don't need to have the linked controls pasted into a subform in order to link the subform to the parent form, in other words, if you have controls you don't want to appear but need them there to link, have the fields in your SELECT statement for the subform, but remove the related controls from the subform sheet.

Works for me