MS Access Form - Horizontal Anchor Affecting Data Update
Posted
by
nicholas
on Stack Overflow
See other posts from Stack Overflow
or by nicholas
Published on 2012-05-29T22:03:32Z
Indexed on
2012/05/30
16:41 UTC
Read the original article
Hit count: 176
ms-access
Running Access 2007 with a databound form.
The form Record Source is set to a query, and all fields in the form have a defined Control Source; nothing fancy, just field names. The form is a Single form with record navigation buttons which perform a "Next Record" and "Previous Record" actions.
As I navigate the records the controls in the header update correctly. However, if I change a control Horizontal Anchor property to "Right" the fields no longer update on record navigation. This is observed for both text box and combo box controls. I can switch the anchoring back to "Left" and the updating works as it should.
Is there some reason anchoring would affect a control updating of in an Access form? Or is this a bug that has been observed before?
The only workaround I can think of is to assign the control text/value property in the form OnCurrent event, but this seems somewhat sloppy. Am I missing something here?
© Stack Overflow or respective owner