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

 173 total views,  1 views today

Show the Cents Symbol

To use the cents symbol on your report or in a TEXT field use the extended ASCII 162, so…

Me.YourTextBox & Chr(162)

 166 total views

 166 total views

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

 183 total views