Microsoft access text formatting

The cell effect describes the style of individual cells. The default setting is Flat , but you can change it to either Raised or Sunken appearance. Select a default width for columns in all the datasheets in your Access database. Type a measurement in inches or centimeters, depending on the system of measurement specified in your Windows settings. By using the settings in this section, you can customize the size, weight, and style of text in datasheets. Size : Select a suitable size for the text in your datasheets.

Weight : Select from the list to determine how thin or heavy you want the text to appear. You can set the text option to Underline or to Italic if you want all the text in all the datasheets to be underlined or italicized automatically.

For more information about setting options for a current database, see Set user options for the current database. Select the arrow next to the current font name to display the list of available fonts. Use the scroll bar or the down arrow to scroll down the list of fonts. Select the desired font to change the font of text. With the text still selected, select the arrow next to the current font size to see a list of common font sizes.

Use the scroll bar or the down arrow key to scroll to the size you want and select it. You can also highlight the current font size and type in a new number to indicate the font size you want. To select a color for their fonts from the gallery, use the following procedure.

Select the arrow next to the Font Color tool on the Ribbon to display the gallery. Or select the same tool from the context menu appears when you select text or by right-clicking. Select the color to change the font color. To review the Colors dialog box, use the following procedure. Select More Colors to open the Colors dialog box. Below are the tools used to add font enhancements. In this example, we will be using the above form to understand how you can use Conditional Formatting to highlight specific pieces of information.

We will now highlight every single project that is currently running late. To apply Conditional Formatting to one field or more than one field, we will need to switch over to the Layout view. On that Format tab, you should see a group called Control Formatting and a special button for Conditional Formatting.

Let us now click on Conditional Formatting. You will now see a Conditional Formatting Rules Manager and currently we have no rules applied to this control. Let us now create a new rule by clicking on the New Rule button. You will now see a New Formatting Rule dialog box. We will first specify the type of rule we will be creating and here we have two options. The first option is to check the values in the current record or to use an expression , and the second option is to compare this record with the other records.

We now have only one of two values in our form; either On Time or the word Late and that is from the given query. We can now set our Conditional Formatting, how we want this field to look like if the word Late appears in that field.

Let us now change the font color to red and make it bold, italic and underline , and that's our conditional rule. If you don't specify a format, Access left aligns all text in datasheets. Typically, you apply custom formats to Short Text and Long Text data types to make the table data easier to read.

For example, if you use a form to collect credit card numbers, and you store those numbers without spaces, you can use a custom format to add the appropriate spaces to make the credit card numbers easier to read. Custom formats for Text fields can have up to two sections. Each section contains the format specification for different data in a field.

For example, if you have a text boxcontrol in which you want the word "None" to appear when there is no string in the field, you could type the custom format ;"None" as the control's Format property setting.

The symbol in the first section causes the text from the field to be displayed and the second section causes the word "None" to appear when there is a zero-length string or Null value in the field. You can use the Format function to return one value for a zero-length string and another for a Null value. To control the format in which data is entered, see Control data entry formats with input masks.

In the Field Properties section, select the General tab, click the cell next to the Format box and enter the specific characters based on your formatting needs.

After you enter a format, the Property Update Options button appears and lets you apply the format to any other table fields and form controls that would logically inherit it. In this case, Field Name is the name of your Text field.

If you choose to apply your changes to the entire database, the Update Properties dialog box appears and displays the forms and other objects that will inherit the new format.

Click Yes to apply the format. For more information, see Propagate a field property. Note: Applying any custom format to Long Text or Memo fields truncates the display to characters.