Visible property on a subform

[artsalive]

Hi

I have just spent an hour trying to work out why I can't make a field invisible on my subform (in datasheet view).

I was working from an example that one of the forums members sent me (which I think was in Access 97 format - I use 2002) where he was able to do this.

I then searched the net and found this:

"your subform is in Datasheet view, and the Visible
property of controls only applies when the form is in
Single Form View or Continuous Forms view. The
controls displayed in Datasheet view really aren't the
same controls, and the regular formatting properties don't
apply to them."

Is this then a difference betweent he two access versions? Or am I missing something?

Thanks for any help.

Ian

 

[pdx_man]

No, there isn't a difference as far as this situation goes. The above statement is true. Do you still have that example?

If the field is on your form, it will show in the Datasheet View independant of the Visible property. Even if it is a calculated control.

 

[artsalive]

Perhaps you would take a quick look at this sample - though I have probably misunderstood something. Mile-O-Phile kindly did it for me.

His suform is in datasheet view, has two fields on it - one of which is visible = no - and yet I try to do the same thing and I can't get rid of it!

What do you think?

Thanks for your input.

Ian

 

[Mile-O]

If I remember correctly, I set the column width to 0.

 

[artsalive]

The field that you get to not be visible is a text box. The only property I can see that you have used is the visible one - and it says no.

I have gone through all the properties of what is a pretty simple set of controls and I have tried to replicate it but mine will not disappear!

Bizarre. I spent a fair amount of time on this little thing last night and revisited it this morning but i cant see what i am doing wrong.

Ian

 

[Mile-O]

Yes, but on the Datasheet View of the form I just changed the Column Width. If you go the left of the column currently displayed on that example and drag it, the hidden column should become visible.

 

[Mile-O]

Look at this:

 

[artsalive]

Thanks for taking the trouble to post that.

Iwouldn't have spotted that in a long time.

Why did you set the visible property to N, if it doesn't have any impact?

 

[Mile-O]

Why did you set the visible property to N, if it doesn't have any impact?

Force of habit.

 

[artsalive]

fair enough!