Access MVP (2010-2015)


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

 229 total views,  1 views today

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

 247 total views,  1 views today

Ampersand not showing in Caption

When using an Ampersand (&) in a Label or Button Caption you get an underscore (Jack_Jill) or nothing (JackJill). To get Jack & Jill you need to double up on the ampersands… Jack && Jill.

Why? In Access the Ampersand is used as a Keyboard Shortcut. So, if you have a Button Caption entered like […]

 8,113 total views