Access 97 Hide form?

[BarryMK]

I want a form which is open but not visible. Is this possible? Minimize won't really do as it will be accessible to users.

Me.Visible = False doesn't work and the .hide syntax in A97 help doesn't either.

 

[Bodisathva]

I want a form which is open but not visible. Is this possible? Minimize won't really do as it will be accessible to users.

Me.Visible = False doesn't work and the .hide syntax in A97 help doesn't either.

...did you remember that in A97, you don't set the value of .hide, just Form.Hide and Form.Show? I remember having to get used to setting the .Visible switch when Access was "upgraded"

and there is this article: http://support.microsoft.com/kb/121899

 

[BarryMK]

Thanks Bod

Tried these amongst others!

Forms!frmFeesHidden.Hide
Forms![frmFeesHidden].Hide
Forms.frmFeesHidden.Hide
Me.Hide

I did find the MS article but will have to wait till next week to recreate it.

 

[Rich]

Me.Form.Visible = False
Screen.ActiveForm.Visible=False
Forms!YourForm.Visible=False

 

[BarryMK]

Me.Form.Visible = False
Screen.ActiveForm.Visible=False
Forms!YourForm.Visible=False

Hey Rich How's the scrumpy?

I'll try it but Form.Visible isn't available in 97 which I have to use for work.

I did find an example in 2002 that I converted back to 97 which did seem to work but I'm loath to put it on our network in case it makes the form flaky.

 

[Rich]

Trust me, .Visible is available in 97, I haven't touched scrumpy since college, or just yesterday

 

[BarryMK]

Trust me, .Visible is available in 97, I haven't touched scrumpy since college, or just yesterday

mmm I know .visible is available in 97, I use it a lot for objects on forms but it doesn't seem to be available for forms themselves, at least I can't find a reference for it but none of the syntax here seems to work. Never mind the dbase isn't dependent on it to work.

Cheers