Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Group/Ungroup Controls

This tip is for Access 2007 and up…

Select all the Controls you want to keep together by holding down the Ctrl key on your keyboard while selecting On the Arrange tab on the Ribbon, select Size/Space then Grouping and click Group/Ungroup

 19,157 total views

 19,157 total views

Set focus to start of field

When you open a Form, the first field (Control) in your preset Tab Stop is always highlighted. This has been known to cause issues…

Users press the Enter key, thereby eliminating the data that was present (and don’t always remember to press Undo). Users begin typing not realizing they are not on a new […]

 6,644 total views

Hyperlink to open Forms

You’re using a Continuous Form, you can’t fit all your fields on the Form but you need to see and/or edit the record and you don’t want to use a Command Button. (Sample file located at the bottom of the article.) Here’s an alternate way to open the record with a Field…

Client […]

 5,473 total views

Refer to Controls on Forms/Subforms

It’s always a nightmare when you’re trying to reference a control from one Form to another or one Report or another. You think you’ve typed it correctly but it’s still not returning the value. Here are two ways to get that accomplished…

From The Access Web… Refer to Form and Subform properties and controls

OR

[…]

 3,345 total views