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: 154

Filed under:

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

Related posts about ms-access