Access Table Tips

Access Table Tips - L Requires a letter ? Allows a letter A...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
PH 647 Spring 2009 jcwolf 1 BITS OF USEFUL ACCESS INFORMATION Formatting Text Fields For this format: Type this format property: Display text all uppercase > Display text all lowercase < Display text left-aligned ! Specify a color Enter one of the following colors between [ ] square brackets: black, blue, green, cyan, magenta, yellow, white Specify a certain number of characters Enter @ for each required character Specify that no character is required & Display pre-defined text /text. For instance, enter /NA to display the text NA. Appears in all records until another value is entered.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
PH 647 Spring 2009 jcwolf 2 Creating Input Masks Input Mask Character What It Allows/Requires 0 Requires a number 9 Allows a number # Allows a space, converts a blank to a space, allows + and -
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: L Requires a letter ? Allows a letter A Requires a letter or number a Allows a letter or number & Requires any character or a space C Allows any character or a space < Converts the following characters to lowercase > Converts the following characters to uppercase ! Fills field from right to left, allowing characters on the left side to be optional \ Displays the character following in the field (\Z appears as Z) ., Displays the decimal placeholder or thousands separator :;-/ Displays the date separator (the symbol used depends on the setting in the Regional Settings section of the Windows Control Panel) Password Creates a password entry text box; any character types is stored as the character but displays as an asterisk (*)...
View Full Document

This note was uploaded on 01/25/2010 for the course PH 647 taught by Professor Wolff during the Spring '09 term at San Diego State.

Page1 / 2

Access Table Tips - L Requires a letter ? Allows a letter A...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online