Access 2007 bug?

[Warrio]

In Form1, place a subForm. Set SubForm SourceObject to Form2.

In Form2, place one or more text box and one button called Button1.
in VBA, on the Click event of Button1 write the following code.
Me.Parent.Form.FormFooter.Visible = True

And then run Form1. In the subform's text box, enter some text and
then press Button1.

Result: The text previously entered disappears. and if you hit a
second time Button1, your text appears again.

Why???

 

[Warrio A]

It is indeed a bug of Access 2007 and 2010 and hope it will be fixed
soon, because I cannot change my forms layout.

Here is the answer from Nathan O. - Microsoft SupportMSFT :
Hi Warrio5,
I was able to reproduce the problem on my end in Access 2007 and in
Access 2010. I then tested the same steps in Access 2003 and the text
does not disappear there.. Since this seems to be behaving differently
in the newer versions of Access, I will file a report on the issue so
the proper people are aware of it.

The only workaround I have found is to move the command button off of
the subform and place it onto the main form itself. Then after doing
this, modify the code so that is looks similar to:
Me.FormFooter.Visible = True

Best Regards,
Nathan Ost
Microsoft Online Community Support

 

[Access Developer]

Help me understand. You have something that doesn't work; you know what to
do to make it work; but you "can't change your form's layout"? Pray tell,
why not? If someone is dictating the form's layout, and would rather have
it not work than have a slightly different layout, they must not be very
interested in the information... that'd be "style over substance", wouldn't
it?

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


It is indeed a bug of Access 2007 and 2010 and hope it will be fixed
soon, because I cannot change my forms layout.

Here is the answer from Nathan O. - Microsoft SupportMSFT :
Hi Warrio5,
I was able to reproduce the problem on my end in Access 2007 and in
Access 2010. I then tested the same steps in Access 2003 and the text
does not disappear there.. Since this seems to be behaving differently
in the newer versions of Access, I will file a report on the issue so
the proper people are aware of it.

The only workaround I have found is to move the command button off of
the subform and place it onto the main form itself. Then after doing
this, modify the code so that is looks similar to:
Me.FormFooter.Visible = True

Best Regards,
Nathan Ost
Microsoft Online Community Support

 

[Warrio A]

Why I don't wanna change my layout? because I use my subForm to load
three different forms. In one of them the CommandButton must be in the
middle just next to the search field. and it is different for the two
others. Of course, I can change by code the layout and do lot of
tuning so my form looks the same after all, but I decided not to! Why?
because I think I have lost enough time on detecting it was a bug that
didn't come from my code, but from Access Developers. They should have
tested their code in all different ways before lunching the upgrade. I
prefer to wait for a fix patch.

Hope I have helped you understand.

 

[Access Developer]

OK, first I thought you said you _could not_ change the UI, but now I
understand that you _don't want to_ change the UI.

Surely, I understand, and you are certainly entitled to your view, but you
do, I hope, realize that you should not hold your breath until you get the
fix. They prioritize those, and some fixes never get done if they decide
that it won't affect many users.

My view has always been, if the users of the database application need the
information (and I wouldn't have implemented 'whatever it was' if they
didn't) it doesn't matter whose fault the problem is, I'm going to get the
information for them if I can. I'm in this business to solve the
user's/customer's business problems, not to make a statement that I'm
certain-sure the developers will not even be aware of.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


Why I don't wanna change my layout? because I use my subForm to load
three different forms. In one of them the CommandButton must be in the
middle just next to the search field. and it is different for the two
others. Of course, I can change by code the layout and do lot of
tuning so my form looks the same after all, but I decided not to! Why?
because I think I have lost enough time on detecting it was a bug that
didn't come from my code, but from Access Developers. They should have
tested their code in all different ways before lunching the upgrade. I
prefer to wait for a fix patch.

Hope I have helped you understand.