barcode generate in asp net The Formatting Toolbar Icons in Microsoft Office

Encode QR Code in Microsoft Office The Formatting Toolbar Icons

Here s how to use the toolbar to format our new controls on the Clients form: 1 Make sure you are still displaying the Clients form in Design view 2 Click the title label in the Form Header section to select it 3 Click the Font tool on the Formatting toolbar and select Times New Roman to change the label s font 4 Click the Font Size tool on the Formatting toolbar and select 16 to change the size of the label 5 Select the State combo box by clicking it 6 Click the arrow on the Fill/Back Color tool (looks like a pouring bucket) from the Formatting toolbar and select the color white from the resulting color palette 7 Choose File | Save from the menu bar to save the latest design changes 8 Display the form in Form view to see your changes

Now that you know how to make and modify a form, you ll want to start entering some data in that form To do so effectively, you ll need to know a little about form navigation In addition, we ll look at some data-entry shortcuts to improve data-entry time

Of course, there is no way around typing much of the data that is to go in your data-entry forms unless of course you hire someone to do it for you! However, there are some keyboard shortcuts that can make that data entry and editing a little bit easier Table 19-2 lists them and what they do

END HOME CTRL-RIGHT ARROW CTRL-LEFT ARROW TAB SHIFT-TAB CTRL-; (semicolon) CTRL-: (colon) CTRL- (apostrophe) CTRL-+ (plus sign) CTRL- (minus sign) SHIFT-ENTER

Function Move to the end of a single line of data in the current field Move to the beginning of a single line of data in the current field Move to the next word Move to the previous word Move to the next field Move to the previous field Insert the current date Insert the current time Insert the value from the same field in the previous record Add a new record Delete the current record Save changes to the current record Remember, moving to a new record also saves changes to the current record

TABLE 19-2

Function Switch between the values in a check box or option button Insert a new line in a text field Undo the last entry Copy the selection Cut the selection Paste the selection

TABLE 19-2

Data-Entry and Editing Shortcuts (continued)

Many forms, such as the Clients form, display your data one record at a time The record navigation buttons are located in the lower-left corner of a form, as shown in Figure 19-2, and help you move through the form s records As the amount of data in your table increases, these buttons will be especially helpful in navigating through the data Another useful tool to help you navigate to a specific record is the Find command, located on the Edit menu The Find command lets you type in a search word or phrase and then searches the data in your form to locate that word or phrase To use the Find command, follow these steps: 1 Click in the field that will contain the data you want to find 2 Choose Edit | Find from the menu bar The Find and Replace dialog box appears

New record First record Next record Last record Previous record FIGURE 19-2

3 Type the text you are looking for in the Find What box 4 The Look In list should already name the field you want to search 5 From the Match list, choose Any Part of Field This choice gives you the most flexibility in finding the text you typed in the Find What box because it instructs Access to locate your search text, whether it is part of a word or a whole word 6 Click Find Next The first record containing the text you are seeking will be highlighted in the field on the form Sometimes you have to drag the dialog box aside because the text you seek can be covered up by the Find dialog box You can also use CTRL-F to open the Find dialog box