Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Quotes within Quotes (Apostrophes also)

You want to use TEXT as the Control Source of a Control on your Form but you keep getting an error OR it doesn’t show as expected because your text contains an apostrophe or quotation mark(s). For help see chart below…

Control Source Property Result Explanation =”This is literal text.” This is literal text. Literal […]

Loading

Show *Enter Password* in a Control

When you have a Log On Form you can indicate what is to be entered by using the Format Property of the Control. By doing it this way the only value stored in the Table is what is entered, Enter Password is only for display.

In the Format Property of the Text or Memo field: […]

Loading

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 […]

Loading

Sunken Controls

In Access 2003 or lower you set your Controls to have the Sunken effect. You upgraded and now you have lost it. To get the Sunken effect back you must…

1. Go to Design View of your Form

2. Click on the Field(s) you want to have the Sunken effect

3. Select a color […]

Loading